Short answer, it depends.

Longer answer, you can reduce the number of round trips required to retrieve data and this can enhance performance. So instead of 3 seperate calls to the...

It sounds like you're getting a deadlock. You can take the advice offered and use a query hint to set the max degree of parallelism to 1 (MAXDOP = 1)....

You say you have a problem when executing, but you're not saying what the problem is. Could you clarify further? Is it a performance issue within a query?

Derek (3/17/2009)

---

There is one table which has a foreign key constraint.. I have to delete all the data in this and while adding new data the primary key should start...

I'm going to hell for this one, I just know it.

I was checking up on the status of what I think is a bug that I posted to Connect (Disabling...

That's pretty inappropriate unless they're actively working on an upgrade which will come out shortly. VERY shortly.

It depends on the queries, but yes, indexes are extremely important. Most important is the clustered index. Here are several great articles on indexes by Gail Shaw [/url](GilaMonster). Even before...

If you're indexes are badly fragmented, it can take a while. You're not experimenting on a live production database are you? That's a recipe for disaster.

Good one.

"You take, Zathras die....

Time And Relative Dimensions In Space...

Of course, I do have a sonic screwdriver in my backpack, so I might be biased.

Jack Corbett (3/17/2009)

---

GilaMonster (3/17/2009)

---

Bob Hovious (3/17/2009)

---

I'm still hoping to one day find sp_MSGoBackInTime documented in BOL. It is THE essential tool for recovering your database when you never...

Also remember that those estimated costs, are estimated, not actual. Execution can be quite a bit different than what is represented, and in a good way.

Sounds like you have the Resource Governor in place. I'm not that familiar with it, but I would suspect there would be some way to set this query to not...

Well done and congratulations. Deliver on half the list and you've earned your raise for the year (and you have an agenda for next year).

I have not personally done an upgrade in that fashion. Based on my understanding of how it works, yes, but that's from reading documentation. If you want to be absolutely...