Monitor VLF counts and transaction log growth with SQL Server DMVs, then choose file growth settings that keep recovery and maintenance predictable.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script
A simple script to retrieve the plan cache for one query and remove just that plan, instead of clearing the whole cache on a busy server.
SQL SERVER – Getting Started with Execution Plans
Execution plans connect a query with the work SQL Server chooses. I start with a small question and inspect the relevant properties.
SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2
Need one more column from a view? Joining table outside view is expensive, and changing the view adds network traffic for every query. Views limitation part 2.
SQL SERVER – Does Order of Column in WHERE Clause Matter?
Does the Order of Column in WHERE Clause change a query plan? I invite a runnable example with a controlled comparison.
Assessing a Database Before a Migration
Assessing a database before a migration covers features in use, compatibility, size, dependencies, and the evidence needed before a date is promised.
Spatial Indexes: Speeding Up Distance Searches
Use spatial indexes for geography distance searches, compare actual plans and reads, and inspect tessellation with built-in diagnostics.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.