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

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.

Speakers:

  • Mike Byrd

    9 Recordings

    Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 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, 10 in 2017, 8 in 2018 (Cambridge) and Chicago, Jacksonville, Dallas, Pensacola, Austin, and Baton Rouge in 2019; as well as several local SQL Server user's groups in Ft. Worth, Austin, and San Antonio; and 2 Virtual DBA presentations in 2018.

Recorded At:

Recorded on:

Aug 25, 2018

More Info:

http://www.sqlsaturday.com/794/Sessions/Details.aspx?sid=82649

Tags: