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

1 vote199 views2 answers
Sql groub by count
SQL
0 vote256 views9 answers
Linq to sql converter online
SQL
0 vote208 views1 answer
Oracle sql copy table without data
SQL
0 vote204 views1 answer
How to insert a uniqueidentifier in sql
SQL
2 votes159 views1 answer
Sql group by different columns
SQL
0 vote293 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote215 views1 answer
Copied text from internet not inserting in mysql
SQL
2 votes188 views1 answer
Oracle sql drop column if exists
SQL
18 votes286 views3 answers
Get the list of all tables in sql server
SQL
25 votes198 views1 answer
Mysql grant all privileges to a user
SQL