That's just what I was going to point out. I even went & checked it in BOL.

No. This wouldn't be helpful to you at all. In fact, it would probably hurt performance.

You're operating under a slight misconception. FAST 'n' (or FASTFIRSTROW) doesn't give you faster response time. It gives you slower response time with the appearance of faster responses. The hint...

That's certainly not a ringing endorsement. Anything in particular force the change back?

Still sounds like you might want to try out VSDB.

First off, get out of the monolithic file. That's going to create headaches no matter what tool you use.

After that, talking about this stuff is almost like talking about religion...

Oh, one other option, you could look at increasing the Parallelism Threshold for the server so that it's less likely to put this query into a parallel operation. That's another...

What you've done with sp_getapplock is completely lock down all the resources used by all the transactions within a given connection. It's a very harsh method for eliminating deadlocks. I...

Whoops. Assumptions will get you. Sorry.

BOL = Books Online. The documentation that comes with SQL Server.

If you can't modify the code directly, but you're getting this error, you may want...

Well, see, I'm right!

😀

It's basically telling you that the procedure had a high enough cost that it thought parallel execution would help. When executing in parallel, it caused a deadlock. First one I've...

SriSun (12/11/2007)

---

I am sorry for giving you very little information.

Actual process: I check for @geolevel (doesn't exist), call another procedure (proc1 which takes couple of parameters along with @geolevel) and...

You only want to put that stuff in as a last resort, usually because of some sort of design error, bad index, or something else that you can't spend time...

What Jason said.

But remember, it's going to force the optimizer to make other choices. Every so often those other choices might work better, but then it's because the HASH join...

Connect with a user that has more restricted rights to the file.