SELECT distinct
    QUOTENAME(s.name) + '.' + OBJECT_NAME(p.object_id) as Table_name,
    p.index_id AS indexid,
    sys.indexes.name,
    partition_number AS partitionnum,
    avg_fragmentation_in_percent AS frag,
    'ALTER INDEX [' + sys.indexes.name + '] on ' + s.name + '.' + OBJECT_NAME(p.object_id) + case when avg_fragmentation_in_percent <15 then ' Reorganize' else ' Rebuild' end as 'Run_it'
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED') as p
inner join sys.indexes 
on p.index_id=sys.indexes.index_id and p.[object_id]=sys.indexes.[object_id]
        inner join sys.objects AS o
        on p.object_id=o.object_id
        inner JOIN sys.schemas as s ON s.schema_id = o.schema_id
WHERE 
avg_fragmentation_in_percent > 5.0 AND
 p.index_id > 0; 

select e.*, 
DB_NAME(database_id) as 'DB_Name', [statement], equality_columns, inequality_columns, included_columns,
'CREATE NONCLUSTERED INDEX ' + 'i' + OBJECT_NAME([OBJECT_ID]) + '_' + replace(replace(replace(ISNULL(equality_columns,''),',','_'),'[','') ,']','')
+ replace(replace(replace(ISNULL(inequality_columns,''),',','_'),'[','') ,']','') + 
' ON ' + [statement] +' ('+ISNULL(equality_columns,'') + case when not (equality_columns is null) and not (inequality_columns is null) then ',' else '' end 
+ ISNULL(inequality_columns,'') +') ' + case when included_columns is null then '' else ' INCLUDE( ' + included_columns + ')' end as 'Draft_for_Script'
FROM
(select  sys.dm_db_missing_index_group_stats.*, avg_total_user_cost*avg_user_impact*(user_seeks + user_scans) as Zatraty
from sys.dm_db_missing_index_group_stats
) as e
inner join sys.dm_db_missing_index_groups
on e.group_handle=sys.dm_db_missing_index_groups.index_group_handle
inner join sys.dm_db_missing_index_details
on sys.dm_db_missing_index_groups.index_handle =sys.dm_db_missing_index_details.index_handle
where DB_NAME(database_id)='test' and last_user_seek>='2014-04-01'
order by /*[statement],*/ avg_total_user_cost*avg_user_impact*(user_seeks + user_scans) desc

exec sp_who2