Websites Reviews, blogging ,SEO,Market Research etc

If you want to do Dynamics Ax Performance Tuning with Missing Indexes then this link is useful for you to get missing indexes, used and unused columns. This important query details mentioned on that links. select d.*  , s.avg_total_user_cost  , s.avg_user_impact  , s.last_user_seek  ,s.unique_compiles from sys.dm_db_missing_index_group_stats s  ,sys.dm_db_missing_index_groups g  ,sys.dm_db_missing_index_details d where s.group_handle = g.index_group_handle and d.index_handle = g.index_handle order by s.avg_user_impact desc