Browse by Tags

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Published 25 January 8 3:41 AM | SSQA.net

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...

Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

Msg: 2522 The index "<name>" (partition 1) on table "TableName" cannot be reorganized because page level locking is disabled.

Published 7 August 7 8:43 AM | SSQA.net

All of sudden the re-org of an index started failing and no error was displayed within that scheduled job we execute. After executing the code from Query Editior I was able to get the message as follows: Msg 2552, Level 16, State 1, Line 3 The index "<name>"...

Filed under: sql server, performance, indexes, service pack, online, allow_page_lock