TempDB performance depends on five settings that you can read in a few minutes: how big it is, how many data files it has, whether they match, how it grows and where it lives. Three read-only queries check each one. The post also explains what to do with the answers.
CHECKPOINT Duration: Can You Speed Up a Manual CHECKPOINT?
The CHECKPOINT duration argument sets a target time in seconds. This post times a manual checkpoint on a database with 130 MB of dirty pages, and shows that a long duration slows it badly while a short one does not make it faster. It also shows that a backup flushes dirty pages by itself.
Ten SSMS Settings Worth Changing on Day One
Review ten SSMS settings for safer connections, clearer results, useful plans, and recoverable query text before starting your everyday work.
The Handful of Counters That Actually Matter
Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.
Peak Concurrency: The Busiest Moment From Start and End Times
Counting sessions per day tells you nothing about overlap. Here is a small event-sweep query that finds the busiest moment, with the tie trap explained.
Capturing Successful Logins With an Extended Events Session
A login event is a connection, not a user action. A small session shows how one query can leave three of them behind.
Countdowns in T-SQL: Days, Hours and Minutes Until an Event
A countdown that says 1 day for a one-second gap is counting boundaries, not time. Here is how to build one that tells the truth.







