A simple script to find cumulative IO per database file in SQL Server, and the real scenarios where this number helps you.
SQL SERVER – FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)
Error 22022 says SQLServerAgent is not currently running so it cannot be notified of this action. Here is what causes it and how to fix it.
SQL SERVER – Are You Suffering from Unknown SSAS Performance Challenges? – Notes from the Field #109
Bill Anton explains how to tell if your app suffers from unknown SSAS performance issues, and why Analysis Services need not be a black box. Notes from the Field #109.
SQL Server 2016 – Enhancements with TempDB
SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
SQL SERVER – Unable to Start SQL Browser
The SQL Browser service on my VM went from Started back to Stopped every time. Here is what the Application Event Log showed and how I fixed it.
Geometry Datatype – Line String Behavior Enhancements
A developer saw slow performance with line strings in the Geometry datatype. I share what I found and the line string behavior enhancements that help.
Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan
Do you use the actual or the estimated execution plan? A candidate asked me this in an interview. I always use the actual plan, and here is why.