Very fun Q 🙂

I particularly like "3+8E8Eight"

Hi Lynn,

Good article concept, this is a problem that I've had to deal with many times, and I suspect most DBAs do at one point or another.

A couple concerns though:

1)...

damn, really nice question, completely threw me. I was thinking about the fact that "sp_*" procs still need an extra property defined in order to act on objects (tables etc)...

Thanks Paul, you've both authoritatively answered the question and provided me with everything I need for a nice SQL Performance testing harness in 2005 (set up, perform N sets of...

Good catch :blush:

I'm still very interested to see whether anyone can tell me more about the difference between the following three...

Good question!

(seeing as we regularly complain, thought I should show some support :))

Hugo Kornelis (7/6/2009)

---

Edit: Afterthought 1: Tao's examples are not great at all. The 1 predicate can match many more rows than the IN(2,3) predicate, so one should expect different query...

Interesting... I was testing in 2000, it did not occur to me to check 2005/2008.

Based on the results above, NOT IN() could well turn into a table scan rather than...

Hi Steve,

Steve Jones - Editor (7/6/2009)

---

People often look for a column not equal to some value, which means every row must be read to determine if it is not equal....

Thanks Hugo, as instructive as always!

(I guess I probably should dig through those ANSI standards at some point... :Whistling:)

In interesting corollary to this question (and, I have to admit, the question I thought it was asking) is "what happens if the number of spaces is different?", eg:

declare @v-2...

Christian Buettner (6/23/2009)

---

Hi Tao, it actually does get deleted for non-clustered indexes as well.

The sentence...

Sorry, I jumped the gun 🙂

Thanks Toreador, I had not noticed the sentence near the top "Disabling a nonclustered index or clustered index on a view physically deletes the index data."

Do you know why it...

Does anyone know whether the fact that disabling an index on an indexed view deletes the index data is noted anywhere in books online?

I found the information in Andy...