As for your challenge:

Before we “take a deep dive” into this, allow me to explain the sproc, a bit. The basic design was put to me as a challenge,...

While this was a good beginner article and I liked the visual references, there is a serious danger in showing this to beginners - Joins with > and < in...

The queries are already reading the indexes not the tables, I moved the groupings around and checked the performance and unfortunately it doesn't make much difference either.

What I have is...

Hello

Ironically the actual problem here is the lack of nolock's in the user application which is whats blocking me in the first place. They are absolutely essential, and I don't...

Hello, Perhaps I don't understand BOL properly...

Firstly - I ran this only as a select in my tests above, no insert's, update's or delete's in sight and it still doesn't...

Thanks for the speedy reply 🙂

We do have it enabled for that database, and I'm looking at breaking the set into chunks and inserting them in transactions with timeouts.

What I...

Hello

I am currently working on a system where Dynamic SQL is used extensively (including dynamic table names, and cursors :(( ). It's a nightmare to work with and debug -...