No suggestions at all? Am I asking too much or not giving enough detail?

I have come up with a structure I think would work but I thought speaking...

I thought i'd just write a follow up for those interested to say we've opted for using OPTION(RECOMPILE) at the end of the query. It doesn't seem to have affected...

it wouldn't be this by any chance would it? 😉 I have your ebook on SQL Server Execution Plans, I read it a while back when i started looking at...

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

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

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

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

Yes, there are quite a lot of them in there actually, it . Any ideas though why it would work for however long, a day, a week etc and then...

I don't think I could post all of it, is there anything in particular you wanted to see? I will do what I can if you give me an idea...

Any idea what the latest date is? I got as far as 500,000 days into the future before i gave up, I doubt i'd have much use for this unless...

I would say fixed width makes it easier to indent your code since every character fits in a same size block. For me, that's the only reason, it's mere...

I liked it like that. It was nice to know that short of copying it letter for letter or using OCR to read the text back, everyone answering should have...

Tom.Thomson (2/15/2010)

---

kaspencer (1/28/2010)

---

However, if you look at an un answered question (next time), you will see that it is actually quite difficult (no doubt deliberately) to read a thread on...

I liked the question, even though I got it wrong.

I answered 10 because I misunderstood how the row_num was going to work. I have been working with row_num quite a...

bitbucket-25253 (2/1/2010)

---

I think that the QOD has two equally valid values.

1. To allow individuals to test their knowledge.

2. To teach.

For those who know the answer it is a...