Thanks Gail, thanks Lynn.

Lynn Pettis (11/12/2009)

---

If X5 only has the values 'A' and 'B' why are you testing for these values in the WHERE clause of your query? If...

And the complex answer? 😉

Actually, X5 only has two values, 'A' and 'B'. Unless using only those two values is better for this specific query, although it goes against what...

My opinion too.

Jack Corbett...

Thanks for the article Gail.

Correction:

In the "Seeks" section, you have "...there must be a SARGable2 predicate..." but then as a reference you have "(1) SARGable is a made-up word, constructed...

Thanks BrainDonor. I've read it, but I'll read it again.

Thanks Ian, it *is* actually exactly what I needed.

Thanks Ian, it appears that this is what I need.

Thank you very much for an extremely informative and eye opening article. Much appreciated and, for me, it's quite a well timed read.

Thank you.

*frustration*

Turns out that much later in the code (a hundred lines or so later in the method) the following line wrote the race to the database again:

"DoRaceCheck"

Yeah, that's the line...

Thanks Gift, I didn't know that.

@Grant: Ouch. That doesn't sound nice at all!

@steve-2: While I was jokingly referring to you with that remark (surely the head of any SQLServer site MUST be an...

Ja, thanks Grant. I wanted to hear some opinions from the DBA world, and I got them. I was expecting a bit more of a harsh response ("O/RM tools are...

Why do you think I'm asking this on one of the biggest SQLServer sites around populated with of the...

Thanks guys. And yeah, I know that it's a "low hanging fruit"-type tool.

Sorry for the double post, the page returned an error so I resubmitted the form.