On January 4, I’m speaking about index internals for the Performance Virtual Chapter
of PASS (http://performance.sqlpass.org).
Here’s my session abstract:
SQL Server provides two kinds of indexes for relational data: Clustered- and Non-Clustered
Indexes. Both of them can be defined as unique and non-unique. In this session
you will learn how to use Clustered- and Non-Clustered Indexes in your database and
how you can improve the execution time of your queries with those indexes. Furthermore
we will have a look into the concrete storage details of both indexes and how they
differ when you define them as unique and non-unique and what's the tradeoff between
it. Finally you will get some best practices how to deal effectively with Clustered-
and Non-Clustered Indexes in your database.
I’m really looking forward to this great chance, and hope that you attend my session.