Index Fragmentation Check.txt
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Index Fragmentation Check.txt as PDF for free.
More details
- Words: 34
- Pages: 1
SELECT object_id AS ObjectID, index_id AS IndexID, avg_fragmentation_in_percent AS PercentFragment, fragment_count AS TotalFrags, avg_fragment_size_in_pages AS PagesPerFrag, page_count AS NumPages FROM sys.dm_db_index_physical_stats(DB_ID('AdventureWorks'), NULL, NULL, NULL , 'DETAILED') WHERE avg_fragmentation_in_percent > 0 ORDER BY ObjectID, IndexID
Related Documents
Index Fragmentation Check.txt
December 2019 11
Fragmentation
November 2019 21
Fragmentation
June 2020 22
Fragmentation Oracle
May 2020 15
Fragmentation To Function
November 2019 14
Distortion Fragmentation
November 2019 12More Documents from ""
Index Fragmentation Check.txt
December 2019 11
Hr_management_project.doc
December 2019 9
Encrypt Communication Channel.docx
December 2019 11
Adj2.pdf
October 2019 22
Sagar Fsg.docx
July 2020 7