If the database is from a more recent hotfix or service pack you need to apply that hotfix or service pack to your machine. Once done you should be able...

Absolutely follow BitBucket's advice.

Just don't run the Profiler GUI directly against any of your production systems. Only use the server side trace (TSQL scripts) against production systems.

You have to use source control as the basis upon which to build the database. Don't edit procedures on the database, edit the scripts and then apply these to the...

I'm with Lynn too. It's either stats or parameter sniffing or both.

To get the execution plans, you can query the dynamic management objects to pull it out of cache directly,...

I've seen major applications done both ways and the single, purpose built table style of design just flat out works better. It's easier to maintain the structures, there are fewer...

We've been experiencing the same thing on one database on our server. I've been running in circles trying to find anything wrong on the database side of things. Finally seeing...

RBarryYoung (12/13/2009)

Actually its the word most often said immediately before someone posts...

Congrats Barry.

I can't decide if "oops" is incredibly sad or absolutely appropriate for the 10,000th post.

GabyYYZ (12/11/2009)

Lynn Pettis (12/11/2009)

GabyYYZ (12/11/2009)

Was the original post a request or a command? (or is it a followup to another thread...

Nah, none of this honor stuff. 10,000 should be a total scramble. Biting, kicking, scratching. In honor of the 10,000.

Looking at the plan, you're still getting scans. Is this taken after you added the index that improved performance...

Actual "estimated" plan.... Is that like honest politician? Kidding.

Plans are either "estimated" meaning they're the plan generated by the...

I have yet to find a need for writing a CLR package of any kind, so I'm not using CLR directly.

However, I do use CLR quite a lot. We have...

You have to then execute the query. It...

No, but the use of fonts sure is.