My apologies.  I corrected the original question to say "double quotes".  Not sure why I did...

Ah... you're correct.  No pivots required for this problem so no Cross Tab (although the code is nearly identical... just missing a CASE in each sum for the non-CROSSTAB stuff). ...

• This reply was modified 5 years, 2 months ago by Jeff Moden.

The thing above (which you posted) is actually "just" a CROSSTAB (which will have a GROUP BY) with a ROLLUP.  With the...

From looking at the results of sp_whoisactive I can see before the CPU got maxed I started to see a high number of RESOURCE_SEMAPHORE_QUERY_COMPILE wait types, these carried on...

I think a good beginner project would be to write a simple checkbook system in T-SQL and then expand on it with thinks like allocation categories in the "memo" of...

It would appear that you have a table full of generic column names and that you're using a different table to define what those column names should be or used...

Sorry, I missed that part.  I would say that it's NOT...

If you stop calling it "Pre-Prod" and start calling it "UAT", there will be no question that it's not actually a production environment.  Of course, no part of...

There's only one way to know for sure... stand up an instance on your dev box and test it.

I...

But remember not all is glitters that is new, MS have had a habit recently of breaking servers with patches, probably best to leave it a month or so...

PRINT may also be substantially delayed an may not show up in some job output in SQL Agent.  I use RAISERROR('somemessagehere',0,0) WITH NOWAIT; for almost real time feedback (but even...

If you want all of that, you should buy a monitoring product where you don't have to worry about what the code actually does.

@rick,

It is sometimes a pain but that's my usual tact... if you know something can/is going to go wrong, you need to be ready to pick up the pieces and...

Allowing failure: Steve and others use children learning as an analogy for this. That works very well because this is childish. When I am a member of your team,...

Heh... as the old saying goes, you have to remember that "NULL is not nothing". 😀