Reindex mssql table

-- mssql use to determine what indexes need to be rebuilt
SELECT S.name as 'Schema',
T.name as 'Table',
I.name as 'Index',
DDIPS.avg_fragmentation_in_percent,
DDIPS.page_count
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS DDIPS
INNER JOIN sys.tables T on T.object_id = DDIPS.object_id
INNER JOIN sys.schemas S on T.schema_id = S.schema_id
INNER JOIN sys.indexes I ON I.object_id = DDIPS.object_id
AND DDIPS.index_id = I.index_id
WHERE DDIPS.database_id = DB_ID()
and I.name is not null
AND DDIPS.avg_fragmentation_in_percent > 0
ORDER BY DDIPS.avg_fragmentation_in_percent desc

Similar codes

0 vote111 views2 answers
T sql null or empty string
SQL
0 vote98 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote107 views1 answer
Oracle list datafiles in tablespace
SQL
49 votes166 views6 answers
Alter table add column
SQL
0 vote103 views1 answer
Sql recherche nom prenom
SQL
0 vote94 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote119 views2 answers
Php convert dbf to mysql
SQL
0 vote120 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
2 votes106 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote110 views1 answer
Redudancy in SQL
SQL