Excellent question and, holy cow, I got it right!

It depends on where you want to go. I'd suggest either looking at more systems work, getting into the hardware & os configurations in a major way, or development, learning...

In addition to the links provided and the information there, just remember, setting MAXDOP is all well and good, but you need to worry more about the parallelism threshold. The...

Gianluca Sartori (5/6/2010)

---

I could try to attach my whole SQL knowledge to that thread, it shouldn't exceed...

I agree.

A company is not an individual and an individual is not a company. Further, you wouldn't want a one-to-one relationship between the two. I work for a company with...

I'm not familiar with the BMC product you're working with, but what's going on is that you have a blocking threshold set within the product. When that threshold is exceeded,...

No, you need to go to TSQL to fix them, usually one at a time.

First time as a DBA huh?

You really, really should hit the books. I...

I'm in agreement with David & Henrico. The one point I would add, and it was touched on by Henrico, is that you really should put growth limits on the...

A query is not selective or not. The data it is accessing may or may not be selective. I don't understand where you're trying to go with this.

You can query...

Lynn Pettis (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

Paul White NZ (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

Make sure you've got your kilts in order gentlemen. Kilt Wednesday at the PASS Summit is going...

I just did some tests with fonts on my desktop. What I do to my operating system (windows 7) happens to my object explorer. I don't know of any other...

Jeff Moden (5/5/2010)

---

Contrary to popular belief, the reads are usually the result of an index or two on the table you're inserting into. There could also be a trigger...

The only reference to that error I saw on MSDN was here. It wasn't related to log backups.

what events are you tracing? You could see this if you were tracing statement and rpc complete, for example.