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 the SQL Server Index B-Tree (from a user perspective)

Speaker:

Mike Byrd

Abstract:

SQL Server has many performance WOMs (Word of Mouth), especially concerning indexes to include: keep clustered index width small, unique indexes perform better, keep non-clustered index width small, compressed indexes have fewer logical reads. This session dives down and looks at important items within index pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command to factually document index WOMs. The effect of row data compression on clustered and non-clustered indexes are also investigated. The demos will ascertain how the SQL Server optimizer might use them and strive to gain some insight from a performance advantage. The session is 80% demos. This presentation will propel the layman to a new level of index understanding. Performance! That’s what we are all looking for. Blast off with this 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.

Recorded At:

SQL Saturday Oklahoma City 2018

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>