var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select top 100 and select top 1000
Just a quick one. I noticed that if I order a column (xyz) which have all values that are same, when I issue a select top command:
statement A: Select top 100 * from table a order by xyz
statement B: Select top 1000 * from table a order by xyz
Some might expect results in statement A should be a subset of statement B. However, this is NOT always the case.
ordering a column that has all values which are the same is indeed stupid, but out of curiosity, I would like to know what optimization techniques sql 2000 to come out with the above results.
Save the dugongs!
Use Query analyzer and see the query execution plan to optimize the query.