My title is Product Evangelist, but my job is Booth Babe.

Chad Crawford (11/17/2011)

---

Wahoo! Just passed the MS 70-453 test, making me a MCITP for SQL 2008 just in time for 2012 to come out. 😀

Very happy - Passing...

Disk queue length is a completely meaningless measure on a SAN system. Some of the other measures are ok, but for details you're going to have to work with your...

Excellent wrap-up. Thanks.

Ninja's_RGR'us (11/15/2011)

---

Grant Fritchey (11/15/2011)

---

Hey everyone. Back from the hole into which I crawled. Did I miss anything? And no, I'm deleting a few hundred emails rather than read through all...

Brandie Tarvin (11/15/2011)

---

Grant Fritchey (11/15/2011)

---

Hey everyone. Back from the hole into which I crawled. Did I miss anything? And no, I'm deleting a few hundred emails rather than read through...

Sounds like you guys covered it all better than I would have. Thanks!

Hey everyone. Back from the hole into which I crawled. Did I miss anything? And no, I'm deleting a few hundred emails rather than read through all this. There'll just...

-Syd- (11/7/2011)

---

Yes, I was aware of that, but I'm from Argentina and our "dear president" (sarcasm) do not allow us to buy dollars or made transaction in dollars, so I...

ionas (11/7/2011)

---

Dear Grant,

regarding your first issue. Every night we run a maintenance plan where we rebuild all indexes. By the way, since we rebulid is it necessary to Update statistics...

And the answer is still the same.

Execution plans are XML saved as a .SQLPLAN file. You can generate them, save them, and attach them, as is. All the data within will be transmitted. The preferred method...

The question I'd ask is not which is faster for the insert, but which supports the SELECT queries better. You're going to load once an hour/day/week/year and then in between...

Before we talk monitoring, let's validate your nightly process. You recreate your indexes and then update the stats? Is that right? If so, you might be hurting performance right there....

Honestly, I doubt there's a single right answer to this. I don't know of anyone who, as a matter of routine, sets their identity values to be DESC. But if...