Index

SQL Server gets an ANSI compliant unique index … sort of

If you work with any of the other big database platforms you’ve probably noticed that SQL Server’s implementation of a unique index is “different” than the others.  Until now there hasn’t been a way to fix that without using a trigger.  Until now… Continued »

So really, how many clustered indexes can I create on a table?

This used to be a very easy question to answer as the answer was 1. However these days, with some creativity you can get some extra ones.

Continued »

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?

SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.

Continued »

Back To Basics: What are indexes and what are they used for?

A while back someone posted on the ITKE forum asking what Indexes where, and what they were used for. I put up a quick answer, but I felt that it deserved a more in depth blog post; so here it is.

Continued »