June 2010 Tip of the Month
By SQLRx Admin | Performance Tuning , SQL Administration , SQL Server , Tip of the Month
SQL Server Administration: SQL Server keeps track of indexes that it thinks it needs in order to optimize queries. But there are several “missing index” dynamic management views that give valuable information. Find missing indexes with this query. Always test the suggested indexes, as they do not always help, and are only suggestions. SELECT mig.index_group_handle, […]
Continue reading