SQL Table Fragmentation Percent

In this blog you will learn SQL table Fragmentation Percent.

Query:

DECLARE @Database NVARCHAR(128)
DECLARE @Table NVARCHAR(128)

SET @Database = N'MYDATABASE'         -- Database
SET @Table = N'dbo.ProposalForm'   -- Table

SELECT
    I.name,
    ROUND(S.avg_fragmentation_in_percent, 2) AS FragmentationPercent
FROM
    sys.dm_db_index_physical_stats (DB_ID(@Database), OBJECT_ID(@Table)
        , NULL, NULL, NULL) S
INNER JOIN
    sys.indexes I
ON
    S.object_id = I.object_id
AND
    S.index_id = I.index_id

Output: