You would need to look at the execution plan to be sure what was happening in the query with the fuction, but yes, using functions like that in that situation...

I am really not a fan of the Database Tuning Advisor, but if you're going to use it, don't use it blindly. Consider it's suggestions very carefully and be sure...

frankG-689606 (5/11/2010)

---

Grant,

You are not going to guess what the solution was...

Do I feel dumb!!:crazy:

Someone brought it to my attention. They asked me, "You do know that the connection timeout is...

frankG-689606 (5/11/2010)

---

Hey Grant,

Thanks for the comeback!

I took some your advice...

Finally, it could be that since you're manipulating all this data all at once, the log file is growing and that's...

paul.goldstraw (5/11/2010)

---

Grant Fritchey (5/11/2010)

---

It's always down to the statistics. Not only how selective is any given value, but where does that value fall within the histogram? That's the primary deteriminant...

paul.goldstraw (5/11/2010)

---

Thanks Grant. Do you know what makes the compiler decide one value is good and one isn't? Because these values are all almost the same. For instance, a value...

paul.goldstraw (5/11/2010)

---

Gianluca Sartori (5/11/2010)

---

It makes sense. Everything I can suggest is trying to convert the code into dynamic SQL. It's fast and it doesn't cache bad plans.

You could use...

Robert Frasca (5/11/2010)

---

I'll do that the next time I run a trace. We capture all of the PerfMon stats for our performance tests so I have literally months of...

I said query hint and I meant procedure hint. I wasn't aware of that 2005 issue though.

That counter is a cumulative count of recompiles. It's probably worth looking at in your situation. To see the affect of recompiles, I'd set up a server side trace and...

Gianluca Sartori (5/11/2010)

---

The only downside I see in using hints is that they have statement scope, not procedure scope. If I remember right, there's an issue still not fixed in...

Without the things that Gail asked for the only suggestion I can make is, reduce the size of the query. Any query 2000 lines long is probably going about stuff...

paul.goldstraw (5/11/2010)

---

Your English is fine 🙂

We did look a long time ago at what plans existed for the procedure. There were two and one was always called by the...

Robert Frasca (5/10/2010)

---

I applied the covered index to the Patient_Info_Fields table as a test on the client's machine and it made the problem go away. I've recommended it as...

Jeff Moden (5/10/2010)

---

There is such a thing as carrying too many tools on your "toolbelt" and...