-
Notifications
You must be signed in to change notification settings - Fork 32
Home
MichelleTaylorRG edited this page Jun 19, 2019
·
5 revisions
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