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.

You wanted four rows instead of three, right? Try this:

select typeId, trypename, typeInfoDesc

from types t left join typeinfo ti

on t.typeId = ti.typeInfoId

AND typeinfoId2 = @infoNr

In a case like this, use the tool above or, if you want to roll your own, SMO (SQL Management Objects) allows you generate SQL scripts by object or for...