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

27 votes243 views5 answers
Add column in table
SQL
0 vote237 views1 answer
Mysql locate
SQL
0 vote234 views2 answers
Create fulltext index mysql
SQL
-1 vote248 views3 answers
How to restart mysql in linux
SQL
0 vote262 views1 answer
Mysql edit trigger
SQL
0 vote236 views1 answer
Mysql match in serialized data
SQL
1 vote257 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote228 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote234 views5 answers
Sql table intermédiaire
SQL
0 vote242 views1 answer
Mysql value ends with
SQL