Geek City: Nonclustered Index Keys

re: Geek City: Nonclustered Index Keys

Dave D. — Thu, 20 Mar 2008 04:37:33 GMT

If the clustered index is also unique in your example, this should not make much of a difference. Just don't implicity include the cluster key.

Dave

http://www.mssqlonline.com/

re: Geek City: Nonclustered Index Keys

Louis Davidson — Sun, 23 Mar 2008 00:37:18 GMT

This kind of detail is so wonderful :) This is why in all of my design books, when I get past the "conceptual" stuff on indexes (and any other internal topics) there is always a note that says something like "If you really want to get deep into how things work, there is a person named Kalen whose book you need to get!" Thanks!

re: Geek City: Nonclustered Index Keys

Mattias Lind — Tue, 01 Apr 2008 18:08:54 GMT

I'm so happy I'm not the only one caring about them indexes... ;)

A year in review, The 31 best blog posts on SQLBlog for 2008

Denis Gobo — Wed, 31 Dec 2008 15:37:52 GMT

Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog

re: Geek City: Nonclustered Index Keys

Bhargav Patel — Wed, 06 May 2009 15:06:22 GMT

Hi Kalen,

very nicely presented.

It now really make sense to create Unique non-clustered index rather than non-unique non-clustered index if possible.

Great article !.

Something for the weekend - Whats the most complex query?

Simon Sabin UK SQL Consultant's Blog — Fri, 05 Mar 2010 16:50:17 GMT

When ever I teach about SQL Server performance tuning I try can get across the message that there is no such think as a table. Does that sound odd, well it isn't, trust me. Rather than tables you need to consider structures. You have 1. Heaps 2. Indexes

Geek City: More About Nonclustered Index Keys

Kalen Delaney — Mon, 08 Mar 2010 00:04:40 GMT

I thought I had said almost all that could be said about nonclustered index keys in a post made almost

Geek City: More About Nonclustered Index Keys

Kalen Delaney — Mon, 08 Mar 2010 00:06:36 GMT

I thought I had said almost all that could be said about nonclustered index keys in a post made almost

re: Geek City: Nonclustered Index Keys

Rajesh — Mon, 01 Oct 2012 07:07:51 GMT

Thanks, Kalen..

got it..in nutshell every index entry must be unique, if not then a cluster key/RID is added at each level(in case od non clustere) or uniqifier in case of cluster,

else if non cluster is unique then no need to add cluster keys/RID at non leaf level, they r just added at leaf level so as to refer actual data row :)

very nicely presented..

re: Geek City: Nonclustered Index Keys

Kalen Delaney — Mon, 01 Oct 2012 17:11:55 GMT

Thank YOU Rajesh ...