Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts here I would like to suggest - How to Detect Table...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-21-2008
Filed under: sql server, indexes, msdn, blogs, rebuild, schema, best practice, schedule, links, performance monitoring, reorganize
As you might come across this BlogPost here but still there are more doubts to be cleared on the reasons for granting Lock Memory in Pages option to the SQL server instance. There is still lot of confusion over there to check whether lock memory in pages option must be set on SQL 2005 and not very clear...