Without looking at execution plans, nope. I can't tell you what's happening. Adding the TOP doesn't "actualize the table in tempdb" whatever the heck that means. It does give the...

Check sys.dm_exec_requests while the query is running to understand what is causing it to wait. That's the best method. Anything else is just guessing.

Just piling on, but, no execution plan, we're just making crazy guesses that will likely have absolutely no bearing on reality.

Oh, and no_lock... that is just such a dangerous crutch...

I primarily only use table variables where I need to avoid recompiles for some reason. Otherwise, the cost incurred by the lack of statistics is almost always not worth it.

In order to rearrange the index, SQL Server must put locks on that index. While locked, other users can't get access to it. The way around this is, if you're...

Jeff Moden (9/23/2013)

---

Grant Fritchey (9/23/2013)

---

Rolled out an explosive. It could be a lady finger or a nuclear bomb. Curious how it's going to go off. Stand by for a fizzle...

Rolled out an explosive. It could be a lady finger or a nuclear bomb. Curious how it's going to go off. Stand by for a fizzle or a big bang.

hisakimatama (9/20/2013)

---

*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking around here,...

steve.fortner 92896 (9/19/2013)

---

Okay, last question. Do they normally "require" degrees at Red Gate? Again, I'm absolutely not questioning the decision - I know you have skills and you're a very...

steve.fortner 92896 (9/19/2013)

---

That sounds like a hard road to plow, but like I said before, I think the whole college thing is stupid. You're right, talking to the right people,...

Instead of applying...

TravisDBA (9/19/2013)

---

There is merit to what you say, but the hard cold reality today is most HR departments require the piece(s) of paper (college degrees, etc.) for technical positions. You...

T.Ashish (9/18/2013)

---

Thanks for your explanation.

So, should I conclude that I do not have to rely on Execution Plan for optimization of my query. Instead, I should check it only for...

And SQL Server 7.0 is self-tuning and eliminates the need for a DBA...

Been there. Done that. Got the t-shirt, the tattoo, the brand, the piercing, the secret handshake and the...

You shouldn't have to get that for restricted user in order to use the immediate rollback.