SQL Server Best Practices Article
Published: September 2007Writers: Sanjay MishraTechnical Reviewers: Tom Davidson, Mark Souza, Prem Mehra, Sunil Agarwal, Mike Ruthruff
Creating and rebuilding indexes are some of the most common database management tasks. Depending on application requirements and data volume changes, the database administrators develop periodic index maintenance schedules. Some of the key factors to consider while you devise an index maintenance plan are performance, concurrency, and required resources. SQL Server 2005 provides you with several options for index create and rebuild operations that you can use to effectively meet the requirements of performance, concurrency, and resources.
For more information, please refer to the TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild whitepaper.
<div style="margin: 0in 0in 0pt; vertical-align: top"><span style="font-size: 10pt; color: black">So how do you&#160;estimate the amount of disk space needed for a ...
Pingback from Tempdb usage « Systems Engineering and RDBMS
Pingback from Twitter Trackbacks for TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild - Whitepapers [sqlcat.com] on Topsy.com
In the section TEST Methodology it says "except that a unique non clustered index cannot be created online"
I am using SQL Server 2008 and I can create a unique clustered index ONLINE.