Why does index reorganizing take 3 times longer after I make an index rebuild? I wasn't sure if this happens every time, so I made a test for the last month. I configured SSMS to execute Index ...
I am a n00b sysadmin and have been asked to completely reorganize an existing machine room with some 30-40 servers. Currently, the place is a pigsty, and wires are jumbled everywhere, so there is good ...
Trying to reorganise an index, the reorganise indexes dialog seems to hang. Which scares me a bit. I'm running SQL Server Standard 2005. The screen has been like this for about 9 hours. The animation ...
I have been going thru documents on Alter Fulltext Catalog Reorganize. But unlike Alter Index Reorganize, BOL(Books Online) documentation does not mention whether it's possible to run it without ...