Explicit Rules
Introduction
Section titled “Introduction”This analysis group contains rules meant to be executed explicitly.
Explicit Rules
Section titled “Explicit Rules”Related Topics
Section titled “Related Topics”EX0004 : Find identifier references inside the T-SQL script
EX0005 : Check script for data modifying statements - INSERT,UPDATE,DELETE or EXECUTE
EX0006 : Identify possible missing Foreign Keys
EX0007 : List all DML and DDL triggers in current database
EX0009 : Consider adding proper comment block before each database object create statement
EX0010 : Identify missing indexes using dynamic management views information
EX0011 : Identify inefficient indexes using dynamic management views information
EX0012 : Displays memory usage information for the current database
EX0013 : Identify fragmented indexes that need rebuilding or re-indexing
EX0014 : List the last execution status of all available SQL Server jobs
EX0015 : Find best clustered index
EX0018 : Analyze execution plan and check for high cost operations
EX0019 : Find references to non-existing objects and columns
EX0020 : Specified text found in comments
EX0021 : Check DROP TABLE statements in order to avoid unintentional data loss
EX0025 : Compressed column used without decompression or updated/inserted without compression