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 vote338 views1 answer
Sql server udf performance
SQL
0 vote351 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
5 votes310 views1 answer
Mysql select greater than yesterday
SQL
13 votes357 views3 answers
Insert mysql ifile nto database
SQL
18 votes324 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote356 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote334 views1 answer
Allow external access to mysql
SQL
0 vote327 views1 answer
Fetch second word from a string in ms sql
SQL
-1 vote350 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote330 views1 answer
How to find username and password in oracle 18c
SQL