This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
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