GilaMonster (8/8/2008)

---

majorbloodnock (8/8/2008)

---

GilaMonster (8/8/2008)

---

There's an interesting correlation between IT (and the wider science field) and martial arts....

Someguy (8/8/2008)

---

I'm surprised how many of the readers here are into martial arts. I hope I don't run into any in a dark alley after my next tech conference. :w00t:

I...

If I were you, I'd do some serious testing. I suspect the cost of maintaining statistics in most systems, for most databases, is a lot lower than the cost of...

I take martial arts training twice a week and I help teach it once a week. I spend a couple of hours most weekends splitting wood. In between times, I...

Thanks. I'm glad it was at all helpful. Keep an eye out for Thomas LaRock articles too. I know he's got a new one coming becuase he let me review...

Although, now that I think...

Usually we bump it up to 20 as a general rule.

Or, you might want to consider increasing the cost threshold for parallelism on your server. I've usually found the default is just too low, causing queries that don't need it...

Is it the log file? Maybe you're in Full Recovery mode and not running log backups?

Pick up a copy of Kalen Delaney's Inside SQL Server 2005: The Storage Engine. That will give you a lot of the kind of information that you're looking for.

The correlated sub-queries at the top of your select statement are going to give you coniptions as this scales. The more data it hits, the slower these will run:

...

You will get slightly better performance combining the two procedures. Avoiding the recompile and the waits that it entails will help.

Honestly though, it's not a solution to your problem. You're...

Log file full

Backup failed

Errors with a severity higher than 16

Those are the three most useful ones.

First, and most important, before you worry about a tool, you need to focus on your process. Discipline around how and when you deploy is more important than the tool...

More than a few of us on are Linked-In. It is like Gail said though, I would only recommend someone after a pretty long relationship that involves more than a...