Again, can't use SUM() OVER for the running total on this one.  The OP said he's actually using 2005.

Then you're doing it wrong.  Please answer the questions I posted or I don't know enough how to help you.

My recommendation would be to do what the industry best practice normally recommends and disable it.  If the phone rings, you'll have your answer and, yes, you should answer the...

Hi, I am running into similar situation, except that my procedure consistently runs slow compared to other environment, when in comparison both environments have similar execution plan and statistics,...

Steve... the OP has posted in a 2005 forum which is before SUM() OVER had the ability to produce a running sum.  I'm thinking we're going to need another "Quirky...

I have a table that is 125GB.  It only has 5 Columns but has almost a billing rows.  This is a fact table that gets regenerated nightly .  I...

If I'm reading that correctly, I'm really sure that's not true.  All non-clustered indexes are...

To the best of my knowledge (and I could be wrong), inserts into heaps follow no order.  They're almost always added to the last logical page of the heap.  That...

I may not have had to rebuild them, but doing a full sample on the statistics definitely fixed the slowness.

Should I have to do a full sample on the...

There's no need to wait... simply use the following code for the...

It doesn't work just in the old punch-card days.  It works fine now, as well.  😀

"Mastery" can also be an illusion... remember that "In the land of the blind, the one-eyed man (even with less than perfect vision) is king".

Thank you, Jeff for taking the time to write and comment your response.

However, I get the following error when I run the script:

Msg 208, Level 16,...

One of the problems that I've witnessed since the fateful day of Monday, January the 18th, 2016 when I discovered that it was the supposed "Best Practice" index maintenance that...

Lordy... Let us hope that MS never makes a DB or Server-Wide setting for this.