One thing you could do is hash the sp text and compare the last date modified. So if the modified date is newer and the hashes don't match, then it's...

Jeff Moden (10/12/2014)

---

sqldriver (10/12/2014)

---

Jeff Moden (10/12/2014)

---

sqldriver (10/9/2014)

---

They insisted something was wrong and that it was always faster. I told them to come back when they found it faster their way....

Eirikur Eiriksson (10/12/2014)

---

This is on a mediocre i5 laptop (E6220), single SSD (3rd gen) and SQL Server 2014, similar results on both 2012 and 2008 R2 on the same system....

Eirikur Eiriksson (10/12/2014)

---

Probably one of the most important factors here is the index maintenance, as the "health" of the index can greatly affect the performance, even in some not so...

Jeff Moden (10/12/2014)

---

That's kind of...

Koen Verbeeck (10/10/2014)

---

sqldriver (10/10/2014)

---

Constraints are evil! Because of uh......

GilaMonster (10/10/2014)

---

It's extremely important to realise that those two queries are not equivalent.

The first...

Grant Fritchey (10/9/2014)

---

The average range rows and the equivalent range rows seem to be pretty accurately distributed. They're extremely close to being roughly the same, except for that 38 outlier.

The...

Yeah! I was reading that, and this part would totally make the non-uniformity make sense if it were grouping on ALL the columns in the index, not just the first:

Histogram

A...

Evil Kraig F (10/7/2014)

---

I've inherited tragedies similar to what you describe.

My first step is to open Visio. My second step is cancel my meetings for a week.

I create a...

Eric M Russell (10/6/2014)

---

sqldriver (10/6/2014)

---

Eric M Russell (10/6/2014)

---

sqldriver (10/6/2014)

---

At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp...

Michael L John (10/6/2014)

---

Agree with Eric. This sounds like something that evolved over time. Little patch here, little patch there, little patch everywhere.

Document, and if possible, clean up the...

Eric M Russell (10/6/2014)

---

sqldriver (10/6/2014)

---

At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp tables, 47 stored procs...

At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp tables, 47 stored procs of varying length, and...

TheSQLGuru (10/6/2014)

---

sqldriver (10/6/2014)

---

If you're tasked with debugging/troubleshooting?

Specifically:

Assigning workable values to parameters/finding out where they're passed from or stored

Heavy use of temp tables/table variables/real tables that get truncated

Verifying results

Bonus points if...