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

The first question I would ask is, do you really need 8000+ rows? You don't really have anything filtering the data down to human readable size. I'd push back on...

You can get the TOP 5 by using the TOP key word:

SELECT TOP 5...

However, you need to order by something. Do you also have a call date? If so, you...

Looking at the XML, the query is still showing up as a LEFT JOIN. This is straight out of the XML from the .sqlplan file:

LEFT OUTER JOINproject_securityproj_security &#xA

The optimizer swapped the...