Cardinality estimation and performance depend on each other: the optimizer guesses a row count, and that guess picks the plan and sets the reads. This post tests one query under the old and the new estimator on SQL Server 2025, shows where the new guess wins and where it loses, and explains how to switch estimators with the smallest possible change.
SQL SERVER – Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071
Finding object dependencies in SSMS takes one right click on View Dependencies. I show how in this short SQL in Sixty Seconds video.
SQL SERVER – Change Fill Factor – SQL in Sixty Seconds #069
How do you change fill factor in SQL Server? This SQL in Sixty Seconds video explains what fill factor is, its default of 100, and how to change it.
SQL SERVER – Copy Database – SQL in Sixty Seconds #067
Backup and restore or detach and attach are not the only ways. This SQL in Sixty Seconds #067 video shows how to copy the database with the built-in copy feature.
SQL SERVER – Poll – What would you love to see in SQL in Sixty Seconds?
SQL in Sixty Seconds is coming back in June. Tell me what you would love to see, and if I build a video on your idea, you get a surprise gift.
SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066
Forgot the SA password or your DBA just left? This SQL in Sixty Seconds video shows how to reset SA password by logging in with Windows Authentication.
SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055
Need SQL Server to wait before it runs the next statement? This SQL in Sixty Seconds video shows the delay command, WAITFOR DELAY, in action.