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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Fri, Jan 25 2008
Filed under:
Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation