SQL Server TempDB Best Practices: Files, Sizing, Contention and Monitoring
Learn the SQL Server tempdb best practices that matter today: how many data files to use, how to size and...
April 21, 2021
Category Archive
SQL Server
SQL Server Collation: How to Change Server, Database and Column Collation Safely
How to change SQL Server collation safely at server, database and column level: a risk and rollback table, tempdb and...
April 14, 2021
SQL Server Backup Compression: Benefits, CPU Cost, ZSTD and Enabling It by Default
How SQL Server backup compression works, what it costs in CPU, how MS_XPRESS, QAT and ZSTD compare, what affects the...
March 31, 2021
Find and Delete Duplicate Records in SQL Server Safely
How to find duplicate rows in SQL Server, keep the right one with ROW_NUMBER, move child records, delete in batches...
March 24, 2021
12 Common SQL Server Performance Tuning Mistakes and What to Do Instead
The SQL Server performance tuning mistakes we see most often, from restarting first and clearing caches to MAXDOP 1, blind...
March 17, 2021
How to Restore a SQL Server Database: SSMS, T-SQL and Point-in-Time Guide
A complete guide to restoring SQL Server databases: SSMS and T-SQL steps, full, differential and log restore sequences, point-in-time recovery,...
March 10, 2021
Can’t Connect to SQL Server? Fix Error 26, 40, 53 and 18456 Step by Step
Why SQL Server connections fail and how to fix them layer by layer: services, instance names, TCP/IP, firewall ports, login...
March 3, 2021
SQL Server Deadlocks: How to Find, Analyze and Prevent Them
Learn what a SQL Server deadlock (error 1205) is, how it differs from blocking, how to capture and read deadlock...
February 17, 2021
SQL Server Data Types: How to Choose the Right Type and Avoid Implicit Conversions
How to choose SQL Server data types for integers, money, text, dates and more, why float is wrong for money,...
April 18, 2018