Boy, I go off to a CodeCamp dinner and come back and BAM - 15 more entries on this thread! 🙂

2 points

1) SELECT ... OVER(ORDER BY...) does guarantee the order...

>>Well...There's got to be a way to use the CTE and ROW_NUMBER() and guarantee an ordered update...

Sorry, but there doesn't have to be. Just because we really wish something...

Minor point: I thought CU4 was build 3200 and CU5 (which you had to explicitly request last time I checked) was 3215. Still if the bug addresses the...

I wonder if it is an HP box and they are being hit with the iLO driver bug.

VERY nice find on that blog post! It sums up the ordered-output issue(s) quite explicitly.

You REALLY need to be talking with PSS about the server crashes.

2 more minor points: 1) 14GB is probably too high sql mem max for a 16GB...

Another (at this time minor) point: 2008-02-06 03:12:12.98 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration:...

Actually, if you have an 18GB tempdb and you never changed the default settings on the server, you now have roughly 18THOUSAND 1MB file fragments scattered all over your drive,...

>>Has anyone heard of any issues similar to this?

Yeah, we all have! :-)) The problem is that the potential causes are quite numerous. Even without knowing your...

check out snia.org for all sorts of SAN training and certification stuff.

It just peeves me to no end to see half-hearted implementations of various established languages like XQUERY, compounded with less than half-hearted implementations of the documentation as to what...

1) For the TSQL limitations remember that there are a bunch of MVPs pushing Microsoft to fully implement the ANSI standards that will allow set-based solutions to this and a...

One more 'out-of-the-box' attempt for this topic: could an XML/XQuery guru out there try to tackle the running total problem from that perspective, if appropriate? I have seen...

I will address the "why queries run fast/slow on 2000 and slow/fast on 2005" question: they have different optimizers. Therefore some queries will run the same, some will...

Thanks for the testing Gila! I wonder if there is an indication hidden somewhere in the full XML plan or exec query stats or some other DMV that indicates...