crainlee2 (3/29/2010)
Wilfred,What is the purpose of this elaborate query?
(NOTE: I have commented out the ALTER INDEX (DISABLE) statement until I get an explanation of what the query is supposed to do.)
I've run it against several test databases using SS2005 and SS2008. Without the ALTER INDEX (DISABLE) clause enabled, it appears to do nothing.
LC
It's an easy way to disable a low performing index, by copy/paste this disable statement
Wilfred
The best things in life are the simple things