Praveen Goud Kotha (8/5/2010)

---

Thank you all the members for their replies/suggestions who participated in my topic..

especially for Fritchey..

If any other reasons for "Reasons for difference in execution plans"..

Please dont forget...

jcrawf02 (8/5/2010)

---

Brandie Tarvin (8/4/2010)

---

Jack Corbett (8/4/2010)

---

Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn...

Praveen Goud Kotha (8/5/2010)

---

Thank you all the members for their replies/suggestions who participated in my topic..

especially for Fritchey..

If any other reasons for "Reasons for difference in execution plans"..

Please dont forget...

She means that yes, the...

What she said.

Total agreement on upgrading the hard way. I've only done a few 2008 to R2 upgrades, but they've been seemless to the point of no one noticing. I'd just be...

Staging tables are frequently a great solution for data import.

Yes, you might get benefits from explicitly updating the stats, especially with a FULL SCAN, or defragging/rebuilding the indexes. It...

In addition to Gail's list:

Different Parameters

Depending on what was deadlocked and how it resolves, you may not get this information. Usually, when we have a system that is experiencing deadlocks, we put a server-side trace...

If you want to literally simulate the entire user experience, with waits and everything, I'd suggest taking a look at Quest's Benchmark Factory. We've been able to use it that...

And there's always the weird stuff. We had a developer accidently drop his access to one stored procedure because he wanted to test security so he revoked his privs, but...

Yeah, true, it doesn't put in pauses. But I don't think that's the worry in this case, unless I'm wrong. Wouldn't be the first time... this hour.

Yes and no. It kind of depends on how big the machine doing the playback is since it will need to thread the calls and may not be able to...

Yeah, I'd go with Profiler as well. The only issue you might run into with that approach is if you have ad hoc SQL that is using deprecated functionality, like...

Brandie is 100% correct. You'll need to reinstall SQL Server.