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...

But if you're using the GUI and you still need to change the schema, display the properties page from the table creation screen. You can change the schema there. Same...

It can be useful if you're returning a large amount of data and you don't want to wait for all the rows to process prior to the data returning. You...

If you're getting primary key violations, something else is up. You may also need to post the structure of the table you're inserting into.

Is that the complete procedure? Is there...