Ok, you have seen many blog posts out there asking for Service pack 3 for SQL Server 2005 (such as Are you ready for SP3 and SQL2005SP3_WorkStarted , it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to...
Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...
