Great question, must say. +1

I just got confused with "NULL value(S)". The last S made it plural and made my guess wrong. 🙁

Good question. Just needed extra attention. 🙂

Correctly said Gail, these two were the DBCC commands which I had used a lot during those days and were really a blessing while looking for optimization. Though now there...

Great question. Got to know about this DMV from this question. Got just 1 point but it was worth.

Thanks for making the last day of the year by giving an easy +1.

Happy New Year to all.

I definitely use DBCC INPUTBUFFER(spid) and DBCC OPENTRAN the most and at times DBCC SQLPERF. These are the most basic, effective and commonly used DBCC commands.

Apart from that I've used...

Perfectly described Lynn.

+1. Excellent link.

Nitin, I've faced such situations in real time scenarios. I tried a lot, moved from here...

Good Point... 🙂 However since the four options provided did not had any "Error" option, the obvious thought came...

Will this help:

SELECT c1

FROM(SELECT c1, SUM(c2) AS 'Adding',(ROW_NUMBER() OVER (ORDER BY SUM(c2) DESC)) AS 'Row'

FROM Table1 t1

GROUP BY c1) a

WHERE Row = 1

Jeff Moden (11/22/2012)

I have to seriously disagree with that. There are usually (I've seen 1 exception) no performance settings or tricks with partitioning disks (there used to be 1...

May your stuffing be tasty

May your turkey plump,

May your potatoes and gravy

have nary a lump.

May your yams be delicious

and your pies take the prize,

and may your Thanksgiving dinner

stay off your...

Thats what I said. I got that DB restored to my test environment and found...

"""""""I removed back that MAXDOP option and rather created clustered index on the temporary table (I know it should have been there in the very first place). Now it worked...

Thanks for confirming that Gail. 🙂