|
|
Browse by Tags
All Tags » msdn » schema (RSS)
-
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 Fragmentation in SQL Server 2000 and ...
-
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 from Books online information on the ...
|
|
|