Ron - at some point if someone decides to place the clustered index on another column then that's the one that will be "ordered by" IF THERE ARE NO OTHER...

Alors...then can we move on to my original request for additional article/s on order/priority of clustered/nonclustered index scanning order?!

Chris - I get the impression that you're in cahoots with Andy/Steve...

(3 ligne(s) affectée(s))....

No - you've never spoken it....just copied and pasted sometimes with french thrown in....

& before you take this too seriously...I was only teasing when I said that!

It's been a laborious and painstaking exercise but I spent all morning creating and testing a dummy table with 3 combinations of 2 columns - clustered and unique nonclustered; clustered...

Joel - thanks for throwing that in - I certainly do not have more than a few thousand rows in all the tables I've tested so far...

Yes - the second one was that defining primary keys do not necessarily mean a clustered index UNLESS (cutting & pasting from BOL to make life easier....):

"IF a clustered index...

Remi - I KNEW you would ask that & I should've addressed that first...

No - I did not since I already had the setup to run queries...I can see what's...

I have a table with an ID PK clustered index column...everytime I query it (regardless of whether my select includes the indexed column or any other combination of columns) I...

No - to which one Frank ?

The filtering and validation should be done on the client side - can you not do this ? Splly. the dd & mm..

Chris - doesn't a clustered index ensure that the rows are always returned in the order based on the indexed column ?!

Also - a primary key doesn't implicitly mean...

or you have a clustered index ?!?!

I tried this on one of our tables with about 7000 rows - running on a VERRRRRRY SLOW network - when the index wasn't clustered it took 22 seconds -...

Frank - make way for the next MVP

Remi - you're amazing!

Haven't had time to compare execution plans yet (bet you already have) - but for sheer brevity and elegance your t-sql...