Viewing 2 posts - 1 through 2 (of 2 total)
I agree that without an ORDER BY clause, the returned result has no meaning.
but can anyone explain, here in the case of Clustered Index, why it picks third record ?
Does...
December 21, 2010 at 7:13 am
#1265057
Excerpt from BOL ...
Aligned index :
For aligned index ,Index is partitioned in same manner as the base table, using same partition scheme and partitioning column.
When a table and its...
November 19, 2010 at 4:02 am
#1252934