Possibly. But I think there might be some samples for how to do it locally.

Run the query with an explicit open transaction statement:

BEGIN TRANS

...

Don't put in a commit until you're complete with your testing.

To give you a complete answer, you'd need to post the code, deadlock graphs, database structures, etc.

To make a few suggestions, Does the table have any other clustered index? If...

Your post is close to the answer. The thing is, SCOPE_IDENTITY will only work for a single row...

Lynn Pettis (2/5/2009)

---

Okay, makes sense (1 and 2). Number 3, I haven't been told that, but I'm not trying to do that much with it and if I was,...

psangeetha (2/5/2009)

---

THanks for your replies. But I think delete restrict will prevent the parent rows from being deleted.

My criteria is when the parent rows are deleted, I dont want...

It's possible for the compile time to be outrageous. We had an 80 table JOIN, plus an extensive WHERE clause that took 45 seconds to compile but only about 1.5...

The last post is close. You do want to use the OUTPUT clause. But instead of trying to use it one row at a time, which is likely to be...

colin Leversuch-Roberts (2/5/2009)

---

I was going to say that profiler does allow to run multi-threaded. The RML utilites will also do the job http://www.microsoft.com/Downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en

but I found the documentation to be...

KSB (2/4/2009)

---

Hi Grant Fritchey,

Yes, I want all these 8000 rows.

For example, you're getting a scan on dim_project_secure's clustered...

1) It's just not open for the kind of manipulation I'm used to making

2) I don't have access to the tools it needs

3) Because I've been told to keep my...

The only problem with Trace, and it's rather big, is that it's single threaded. So instead of multiple threads for multiple sessions, you get a single thread for all sessions....

And I've been staying out of the way since this was identified as PeopleSoft. Same approach I take at work.

You can...

With kids in the picture, considering the state of the economy, no, I don't think I would move to consulting at this time. Shifting jobs... Yeah, if the offer was...