Home

Welcome to the SQLCop wiki!

Current test documentation:

• Ad Hoc Distributed Queries
• Agent Service
• Auto close
• Auto create statistics
• Auto shrink
• Auto update statistics
• Buffer cache hit ratio
• Column collation does not match database default
• Column data types numeric vs int
• Column name problems
• Columns of data type Text or nText
• Columns with float data type
• Columns with image data type
• Compatibility level
• Database and log on same disk
• Database collation
• Database mail
• Decimal Size Problem
• Forwarded records
• Fragmented indexes
• Instant file initialization
• Login language
• Max degree of parallelism
• Missing foreign key indexes
• Missing foreign keys
• Old backups
• Ole automation procedures
• Orphaned Users
• Page life expectancy
• Procedures named SP_
• Procedures that call undocumented procedures
• Procedures using dynamic SQL without sp_executesql
• Procedures with @@Identity
• Procedures With SET ROWCOUNT
• Procedures without set nocount on
• Service Account
• Table name problems
• Tables that start with tbl
• Tables without a primary key
• Tables without any data
• Uniqueidentifier with NewId
• Unnamed constraints
• User aliases
• Varchar size problem
• Wide tables
• xp_cmdshell is enabled

Outdated tests:

• SMO and DMO - SSMS now uses these
• Views with order by - this is only a problem on SQL 2005 / early SQL 2008