embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Climbing SQL Server Index B-Tree (from user perspective)

Speaker:

Mike Byrd

Abstract:

This session dives down and looks at the important items on data pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command. It will also look at the effect of row data compression on indexes. In all demos we will try to ascertain how the SQL Server optimizer might use them and also strive to gain some insight from a performance advantage. Its purpose is mainly to try and understand how SQL Server implements indexes, their underlying structure, and where performance benefits might lie from a layman’s viewpoint. Session is 80% demos. This is an intermediate level presentation.

Bio:

Former rocket scientist and USAF Fighter Pilot — now a SQL Server geek (22 years). Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies. Presenter at 17 SQL Sat sessions in 2016 plus 10 in 2017. Presented TSQL Precon at Dallas SQLSaturday 2015. Instructed several TSQL classes to private businesses including Advanced TSQL class to Solarwinds Corp, Austin, TX last year. Currently performing DBA/Developer work for several clients. Specialties: SQL Server performance tuning; TSQL/DBA mentoring

Recorded At:

Austin SQL User Group

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>