Home > IT Blogs > SQL Server with Mr. Denny >

SQL Server with Mr. Denny:

Clustered Index

Mar 26 2009   3:00AM GMT

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



Posted by: mrdenny
Index, Clustered Index

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 »

AddThis Social Bookmark Button     0 Comments     RSS Feed     Email a friend

Feb 2 2009   1:31PM GMT

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



Posted by: mrdenny
Index, Back To Basics, Clustered Index, Nonclustered Index

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 »

AddThis Social Bookmark Button     2 Comments     RSS Feed     Email a friend