Definitions More Info.
Definition ID	4.049
Title	SQL
Category	NOTES
Definition	Tablo-table bazinda index fragmentation
Definition Description	https://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/ NOT: SADECE PRIMARY KEY INDEX BAZ ALARAK OLCUM YAPMAKTADIR. DIGER INDEXLER DAHIL DEGILDIR !!! SELECT [avg_fragmentation_in_percent] FROM sys.dm_db_index_physical_stats ( DB_ID (N'KNET_BI_DWFact'), OBJECT_ID (N'ApplicationHistoryTransactionFact'), 1, NULL, 'LIMITED'); GO
RecordBy	cunay
Record Date	20-12-2020 15:30:39
Düzenle
Kopyala
Sil