Vipul Shah's SQL Blogs

SQL Server Blogs

December, 2007

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