Buun.
Incercarea nr.1 (cu modificarea numai a bazei de date la care se lucreaza):
http://sqlfool.com/2009/06/index-defrag-script-v30/
Incercarea nr.2 (cu modificarea numai a bazei de date cu care se lucreaza):
http://ola.hallengren.com/
De ce la o verificare a starii fragmentarii indecsilor, datele raman neschimbate?
Scriptul de verificare:
SELECT ps.database_id, ps.OBJECT_ID, ps.index_id, si.name, ps.avg_fragmentation_in_percent,
(SELECT distinct so.name FROM sys.objects so INNER JOIN sys.indexes ON so.object_id = si.object_id) ParentTable
FROM sys.dm_db_index_physical_stats (NULL, NULL, NULL, NULL, NULL) AS ps
INNER JOIN sys.indexes si ON ps.OBJECT_ID = si.OBJECT_ID
AND ps.index_id = si.index_id
WHERE ps.database_id = DB_ID() AND si.name is not null AND
ps.avg_fragmentation_in_percent > 30
ORDER BY ps.avg_fragmentation_in_percent desc
GO