Quick suggestion, run a DIR before and after, the difference in the counts are the number of files deleted

😎

Is it simply blocking or is it dead-locking?

😎

A comic situation would be two threads trying to write to the deadlock file at the same time...:-D

laughing

Shark...

Digressing slightly, how would the threadizens describe the optimal code comments? Obviously the opposite of that would be the worst;-)

😎

Don't take this bad but being blatant and straight to the point, given the lack of quality and the level of naivety portrait in the code posted, I strongly recommend...

First a quick question, why the nolock hint? Are you running of a read only database? If the database is not read only then remove the nolock hints, re-run the...

Can you post the full code, ddl and some sample data please?

😎

Gary Varga (3/13/2015)

---

Toby Harman (3/13/2015)

---

Many years ago I found a comment by my boss in the code which read something along the lines of

-- Don't touch this code

-- It does...

Quick thought, could it be that changing the compatibility level flushes the plan cache and that's the real culprit?

😎

Seen everything between a shopping list to poetry, not bothered too much by those, at least not as much as having several hundreds of routines which all had a very...

The beginning and terminating single quotes / apostrophes are missing from the sp_MSforeachdb parameter.

😎

Recommend using Ola Hallengren's scripts[/url] rather than rolling your own.

Ed Wagner (3/12/2015)

---

Yout might pay closer attention to the news than I do. Another possibility is that...

Dwain,

found the cost of the #Temp inserts being the greatest actual cost variant, much stabler results using "bucket" variables, regardless of the function used.

Did some slight changes to...

Quick question, this is a normal size Strat in your picture then?

😎