SQL Server Mising Index

The SQL script is used to identify the missing index in SQL Server

       SELECT dm_mid.database_id                                         AS DatabaseID, 
       dm_migs.avg_user_impact * ( dm_migs.user_seeks + dm_migs.user_scans ) 
       Avg_Estimated_Impact, 
       dm_migs.last_user_seek                                     AS 
       Last_User_Seek, 
       Object_name(dm_mid.object_id, dm_mid.database_id)          AS [TableName] 
       , 

SQL Server Reindexing Query (By Index)

This query is used to reindex the SQL Server database tables index by index

DECLARE @tableName NVARCHAR(500) 
DECLARE @indexName NVARCHAR(500) 
DECLARE @indexType NVARCHAR(55) 
DECLARE @sql NVARCHAR(500) 
DECLARE @percentFragment DECIMAL(11, 2) 
DECLARE fragmentedtablelist CURSOR FOR 
  SELECT '[' + Object_schema_name(ind.object_id)