Session
Climbing the SQL Server Index B-Tree
You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially
when it comes to indexes. Some of the things you have probably heard are:
keep clustered index width small
unique indexes perform better
keep non-clustered index width small
compressed indexes have fewer logical reads
add one index for each column
But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice.
Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about
performance, and the right indexes will give your application a big performance advantage.
Mike Byrd
ByrdNest Consulting, Senior Database Engineer
Marble Falls, Texas, United States
Links
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top