For me the reserve isn't that you shouldn't do it. I simply think that there is probably at least on server dedicated to processing these and similar requests and that's...

Agree... and since it is I'd probably never put it on the SQL Server. Cool that you...

I got it... sound logical. One more thing though.

If the included columns is not creating a covering index, will the included columns still be read or is it then only...

I know it's an old topic but how is included columns affecting memory footprint? Some say higher use to put index in.memory cache. Some say lower since less pages are...

Thanks! Most helpful!

That can be accomplished by using the NOLOCK hint?

I think he means that whatever works for you...

Jeff Moden (9/27/2012)

---

Heh... whatever happened to the idea that you can write bug-free database code? Am I the only one that still thinks that should be the rule rather...

Matt Miller (#4) (9/27/2012)

---

Kristian Ask (9/27/2012)

---

Not to look down on test like unit-test but even if the tests are well-written they hardly find more than 40% of the bugs anyway....

Not to look down on test like unit-test but even if the tests are well-written they hardly find more than 40% of the bugs anyway. There's a fine line of...

Steve Jones - SSC Editor (9/17/2012)

---

Jeff Moden (9/16/2012)

---

I've found that such "committee decisions" can be horribly wrong especially when people who might not know as much about databases outnumber those...

Jeff,

Great reading!

I was reading the entire post just waiting for your test.... good thing you already did it once. Personally I've been replacing quite a few rCTEs because they just...

Jim Johannsen (3/27/2012)

---

"I have NEVER seen a GUI query designer that was good for developing queries with ANY level of complexity. They are at best handcuffs and much like wizards...

Thank you very much for both replies... exactly what I needed to know.

I managed to be persuasive enough to keep it off the prod server for now and a test...

Brilliant 😉