The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Climbing the SQL Server B-Tree

Wed, Oct 24 2018 16:00 UTC

Climbing the SQL Server B-Tree

SQL Server® has many performance WOMs (Words 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.

Mike Byrd

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

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.


Follow us on Twitter: @PASS_DBA_VC

Back to Top