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...

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...