Any chance your query is using NO_LOCK?

That can absolutely lead to missing rows.

Yeah, someone has 'sa' privileges.

You might also look at the system_health extended event session. It captures some modifications along these lines (but not all).

I'm with Gail. It's very likely that your process is working, but capture the deadlock graphs from production just to be sure that you're dealing with the same objects. Then...

ChrisM@Work (2/5/2015)

---

Grant Fritchey (2/4/2015)

---

SQLRNNR (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

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,...

patrickmcginnis59 10839 (2/4/2015)

---

dwain.c (2/4/2015)

---

patrickmcginnis59 10839 (2/4/2015)

---

dwain.c (2/4/2015)

---

Sounds like a problem I had recently and the same solution too.

SQL Query invoked by Crystal Reports v9.2 Performance Issue

I'm a great believer in...

No, not for a bad parameter sniffing problem.

Get the estimated plan....

Excellent. Make sure to look at the execution plans to see how the queries resolve based on the new design. Thanks for the follow-up post.

New Born DBA (2/4/2015)

---

ScottPletcher (2/4/2015)

---

The key thing for performance is the clustered index. Yes, you can instead create gazillions of nonclustered covering indexes, but that actually doesn't help overall...

In that case, it's referencing the object, not the call, so the text is showing the object definition.

Thanks for reporting back what worked. That's really good to know and useful for people who find the question and answers when searching.

Brandie Tarvin (2/4/2015)

---

Ed Wagner (2/4/2015)

---

Brandie Tarvin (2/4/2015)

---

So I finally got my "training materials" for SQL 2012. The High-Performance T-SQL Using Windows Functions by Itzik Ben-Gan (smaller book than I thought...

SQLRNNR (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

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...

New Born DBA (2/4/2015)

---

Lowell (2/4/2015)

---

to satisfy that specific query, i think an index on the four columns involved int he WHERE clause is needed, and INCLUDE all the columns in...

Oh, that's easy. Look at the first operator from the execution plan. It's stored...