-
Notifications
You must be signed in to change notification settings - Fork 32
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 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 SMO and DMO 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 Views with order by Wide tables xp_cmdshell is enabled
Outdated tests:
Ole automation procedures - these are needed for SSMS