Cool info on ALTER INDEX ALL

I learn something every day.

Perusing the MSDN blogs, I noticed a cool one by Joe Sack that I wanted to make note of here... it doesn’t appear that Joe blogs a whole lot, but when he does, it’s usually worth reading.  This time he writes about the TSQL command ALTER INDEX REBUILD and its behavior.  I just used this the other day and didn’t know this information. Check the post out at http://blogs.msdn.com/joesack/archive/2010/03/09/alter-index-all-rebuild-behavior.aspx for his info.  And remember that a “heap” is a table with no clustered index. This includes tables that have between 0 and 999 nonclustered indexes.  (I think that’s the max, but I recommend never putting on more than 850-875 per table LOL).  Good read!

Lee Everest

------------------------

I just might actually put 999 nonclustered indexes on a table some day and see wut up. You in?