SQL Server Maintenance Tasks
Essential SQL Server maintenance tasks for accidental DBAs: backup strategies, consistency checks with DBCC CHECKDB, index rebuilds, and understanding RPO/RTO.
·
3 min read
Posts
Implicit Conversion in SQL Server
How to audit your database for implicit conversions, identify data type mismatches across columns, and find conversion warnings in the plan cache.
·
1 min read
Understanding HEAP Tables
Why SQL Server heap tables cause performance problems through full table scans and forwarding rows, with a demo showing the I/O impact and how to fix them.
·
6 min read
Database Design - Why Does It Matter
Why data type selection matters for SQL Server performance, memory usage, backups, and long-term scalability, with concrete byte-savings examples.
·
3 min read
Database Design Part 1
An introduction to SQL Server database design covering data type selection, table structure, and why thoughtful design matters for long-term performance.
·
2 min read
Database Table Size
A reusable SQL query to report row counts, total space, used space, and unused space per table and schema using sys.allocation_units.
·
1 min read
Moving to SQL Server 2014/2016
Key considerations when migrating to SQL Server 2014 or 2016, including the new cardinality estimator, edition changes, and version downgrades.
·
2 min read