Sajal Dam wrote the SQL Server 2000 version of Query Performance Tuning Distilled, and his name is still on the 2008 version since about 20% of the text is still...

I'm entirely unsure of what I changed, but it's working now. I feel like an idiot because it should have worked. It looks good now... thanks for the help.

I'm sorry. You're right. That was just a typo I made after I copied & pasted. I'm using the correct property or I'd get an error. It's just not returning...

Krishna Potlakayala (5/11/2009)

---

But Why a job every night if you have Auto Update statistics ON? You either have to have Auto update Statistics ON or OFF and run a job...

Do you mean you're using Visual Studio Team System Database Edition, or just the regular Visual Studio with a database project? I'm asking because you talked about Schema Compare &...

I'm assuming that the update statistics is not based on a full scan. It's possible that the data in a sampled scan doesn't result in statistics as good as that...

GSquared (5/11/2009)

---

I had...

I'd crack a joke about only wanting SQL Server info from black belts, but I'd be reading from Itzik, Kalen, Gail... I'm not sure who else. No worries there.

GilaMonster (5/11/2009)

---

Samuel Vella (5/11/2009)

---

Problem with the "point and click" interface of SQL Server is that a lot of DBA's can get through their day job without having to *think* about...

Hard to know, but I'll bet it's related to the size. Based on your descriptions and the documentation, I'd guess that was it.

Well to get the thread back "on topic" (as if), this one has managed to raise my blood pressure with his/her response.

Suffice to say. I'm done.

Samuel Vella (5/11/2009)

---

Also someone with 7 years DBA experience could well have only 6 months. The other 6 and a half years is really developer experience which they have fudged...

The issue is, the waitfor is not a part of the procedure itself. So the procs ran in the time reported. It sounds like you're trying to get client side...

I think Brent & Gail's advice is best. You have to get involved, somehow, with actual database work.

I started out in development by building apps and doing tech support...

Same question I was going to ask. Why only Indian authors? Wouldn't it be better to just go for the best books, regardless of the ethnic origin of the author?

For...