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
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 constructs and uses indexes. It’s all about performance, and
the right indexes will give your application a big performance advantage.
Some knowledge of T-SQL and Management Studio is recommended.