Welcome to TechNet Blogs Sign in | Join | Help

December 2007 - Posts

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
Posted by vishah | 0 Comments

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
Posted by vishah | 0 Comments
 
Page view tracker