Finding Missing Indexes and Unused Indexes using DMVs

Finding Missing Indexes: Dynamic management object Information returned sys.dm_db_missing_index_group_stats Returns summary information about missing index groups, for example, the performance improvements that could be gained by implementing a specific group of missing indexes. sys.dm_db_missing_index_groups Returns information about a specific group of missing indexes, such as the group identifier and the identifiers of all missing indexes…

2

DDL Triggers and LOGON Triggers

DDL Triggers:  DDL triggers can be used for administrative tasks such as auditing and regulating database operations. Use DDL triggers when you want to do the following: ¾  You want to prevent certain changes to your database schema. ¾  You want something to occur in the database in response to a change in your database…

2