Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

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.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Help

SQLCop

SQL server

Google Ads

Detected issues


Code

Column

Table/Views

Indexes

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