The DTA relies on statistics from your data and your database as well as the queries that you've captured in your trace events file. It uses those to evaluate the...

Koen Verbeeck (6/27/2012)

---

Grant Fritchey (6/27/2012)

---

Koen Verbeeck (6/26/2012)

---

Well, I did the best I could.

I 'liked' the book on Amazon, gave it...

Based on that query code for the procedure, you can do the entire thing just by joining the query that fills your cursor to the update statement. You can do...

Just so we're clear, a WHILE loop is...

Youch! That's a real horror story.

Koen Verbeeck (6/26/2012)

---

Well, I did the best I could.

I 'liked' the book on Amazon, gave it 5 stars and wrote...

OK, but I'm still in the dark here. You saw slower performance on a server with slower & fewer CPU? That's kind of normal. If your system was well tuned...

SQLKnowItAll (6/26/2012)

---

Grant Fritchey (6/26/2012)

---

SQLKnowItAll (6/26/2012)

---

Grant Fritchey (6/26/2012)

---

Assuming we're talking about a data file and not a log file, something had to have filled that space. Do you have load processes...

Hard to know. What's different about the different servers? Is one faster than another, more memory, more cpu, different kinds of disk storage, different settings on the sQL Server instance,...

It sounds like it might be bad parameter sniffing. When the query is running correctly, get a copy of the plan out of cache & store it on the side...

SQLKnowItAll (6/26/2012)

---

Grant Fritchey (6/26/2012)

---

Assuming we're talking about a data file and not a log file, something had to have filled that space. Do you have load processes or queries that...

WayneS (6/26/2012)

---

I'm curious about what is being done to ensure that something like this doesn't happen...

Brandie Tarvin (6/26/2012)

---

Grant Fritchey (6/26/2012)

---

Sorry....

Oh, and a nice horror story for you all[/url].

Sorry. I'll be down in...