Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 031
We got 31 flavors of tidbits for ya…
“I’d like some more information on the requirements for online defragmentation and indexing.”
Well, first of all… The new online index operations are only available in the Enterprise edition of SQL Server 2005.
The SQL Server 2005 Books Online has a great section on the requirments for performing Online Index Operations.
From the manual…(And if you have the books online already installed, clicking on this link will bring you right to the correct topic: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d82942e0-4a86-4b34-a65f-9f143ebe85ce.htm)
When you perform online index operations, the following guidelines apply:
The following table shows the index operations that can be performed online and the indexes that are excluded from these online operations. Additional restrictions are also included….
See the books online for the table, plus some additional considerations of Disk Space, Performance, and Transaction Log loads.
Got an IT question? Give me a comment, or contact me.