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.

-Klaus