Sioban Krzywicki (2/4/2015)

---

Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot put, discus, javelin). It was less than twice...

Without more evidence, I don't know.

It could just be bad parameter sniffing. It could be something else. Gather to data to be sure.

It's also possible that you're seeing differences in the plan because of ANSI connection settings being different between SSMS and the web app. Because, assuming you ran the query with...

This usually has one of two causes. The first, and the easiest, is that your statistics need to get rebuilt. They'll be rebuilt automatically as you use them, but they'll...

Eirikur Eiriksson (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Nah, I hear he's a giant bag of...

shew (2/4/2015)

---

I ran across a copy of your "SQL Server 2012 Query Performance Tuning" book this morning. This...

Brandie Tarvin (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Nah, I hear he's a giant bag of wind and...

Nah, I hear he's a giant bag of wind and a bit of a...

One source of suggestions (and please, note that word, suggestions) for columns that might need an index are the Missing Index DMVs. But, the problem with using these is two-fold....

I too am not a fan of Management Data Warehouse. It works well enough, but misses so much you have to do a ton of extra work to get a...

Basically, there's a lock in place during execution to prevent updates during execution. That's all.

Ed Wagner (2/4/2015)

---

So,...

Just to toss another point of view in here, admittedly one that is vendor centric.

I work for Red Gate Software. I've used both our products and litespeed in production...

SQL Guy 1 (2/3/2015)

---

If you see a chain of blocks that hold waiters for a long time, you can kill the spid that is in the very beginning of...

The best way to monitor in SQL SErver 2008 or better with minimal impact on the server is to use Extended Events. Here's an article[/url] that specifically shows some suggestions...