endeavour (10/19/2009)

---

Thank you for the helpful replies it seems like the concensus is 'it depends'.

Rather than my describing a single theoretical context,

has anyone actualy hired a consultant to advise on...

Yes.

Even if you have talent in-house for tuning performance, you might need to bring in outside help if you're busy or, worst of all, when management doesn't trust that you're...

The cost values displayed in execution plans are estimates. Becaues of this, they won't always add up to 100% or they may add up to WAY over 100%. It's nothing...

Just so you know, this can frequently result in slower backups that cause some visible load on the server. I prefer to backup locally and then move the file across...

There must be an error message reported in the maintenance job or in the logs. Find that error. If it doesn't tell you exactly what the problem is, post it...

Funny, I'm going to come down just the opposite and say that I like option B for the same reasons that Jeff likes option A. I don't like having to...

No accountants here either... Nurses, Receptionists, Sales people... those I've seen try to be DBA's. Nurses weren't so bad, neither were the receptionists... keep the sales people away from the...

It sounds like a classic case of parameter sniffing. Try updating your statistics. If that doesn't resolve the issue, you may need to use an OPTIMIZE FOR hint on the...

And I've seen the opposite. Until a recent bug fix, it was missing indexes that were blatant and obvious that resulted in major performance improvements. There's an MS Connect issue...

I like the OUTPUT mechanism for batch inserts, but if you're doing single row inserts, you should be fine with SCOPE_IDENTITY() in almost all cases. If you read through the...

Thanks. We'll try that too.

For some reason when we turned implicit transactions off, we were able to get the install to run. I'm still trying to find out why one...

Layne-812700 (10/19/2009)

---

Grant Fritchey (10/16/2009)

---

Layne-812700 (10/15/2009)

---

whatever size or type of data I use, they present the same result. You might disagree, but the first one is only a shortcut in my...

maperkins (10/19/2009)

---

Good DBAs in History: How about George Washington Carver.

Thousands of experiments, many resulting in useful ( or delicious) products. He even made a diamond out of...

Fallen Angels

If it's making calls to the database you should be to see them. If you're not seeing them, there must be something wrong with your trace configuration, server settings, filters......