Yeah, I noticed this "improvement" in 2005, but I couldn't find any documentation as to why this suddenly "works". I haven't taken the time to test other such functions...

Thanks to everybody for the quick responses.

Yes, I understand that without a "where" clause there is no guarantee of the row order, but I just thought it was very...

Steve Jones - SSC Editor (12/6/2010)

---

It shouldn't matter, but are you just running this script, or is someone changing this in the GUI? It's possible that there is a bug...

OK, yes, that makes sense. For some reason I thought that each instance had its own copy of the data on its "own" disks...thanks!

Yeah, you're right about security. The reason I brought it up was that I vaguely remember doing something like this in SQL 2000, but I couldn't find it in 2008....

Thanks for the link

OK, still a bit confused:

From this link : http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx#E5D

It says "For example, the query can be submitted under "set showplan_xml on" mode. If the...

OK, thanks! Btw: you don't know of any type of perf monitor counter that would show this?

Thanks all. I actually use a code snippet very similar to the count from inserted/deleted tables.

OK, thanks to everybody for the quick responses. I guess I was a bit optimistic about the powers of alter index.

No errors...I did a dbcc indexdefrag and got

pages scanned 7

pages moved 0

pages removed 0

the index is showing frag % = 85,7142857142857

I even dropped and recreated the index and the frag...