Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
SQLCop
Google Ads
Detected issues
Code
- Procedures with SP_
- VarChar Size Problems
- Decimal Size Problem
- Undocumented Procedures
- Procedures without SET NOCOUNT ON
- Procedures with SET ROWCOUNT
- Procedures with @@Identity
- Procedures with dynamic sql
- Procedures using dynamic sql without sp_executesql
Column
- Column Name Problems
- Columns with float data type
- Columns with image data type
- Tables with text/ntext
- Collation Mismatch
- UniqueIdentifier with NewId
Table/Views
- Table Prefix
- Table Name Problems
- Missing Foreign Keys
- Wide Tables
- Tables without a primary key
- Empty Tables
- Views with order by
- Unnamed Constraints
Indexes
- Fragmented indexes
- Missing Foreign Key Indexes
- Forwarded Records
Configuration
- Database Collation
- Auto Close
- Auto Create
- Auto Shrink
- Auto Update
- Compatibility Level
- Login Language
- Old Backups
- Orphaned Users
- User Aliases
- Ad Hoc Distributed Queries
- CLR
- Database and log files on the same physical disk
- Database Mail
- Deprecated Features
- Instant File Initialization
- Max Degree of Parallelism
- OLE Automation Procedures
- Service Account
- SMO and DMO
- SQL Server Agent Service
- xp cmdshell
Health
- Buffer cache hit ratio
- Page life expectancy
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.