Monitor VLF counts and transaction log growth with SQL Server DMVs, then choose file growth settings that keep recovery and maintenance predictable.
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 – ORDER BY Does Not Work – Limitation of the Views Part 1
Why ORDER BY does not work in a view: the first limitation of views in my series, shown with an AdventureWorks example. Sort outside the view instead.
SQL SERVER – Computed Columns – Index and Performance
The last article in my series on computed columns looks at index and performance, with a summary of every earlier part on storage and PERSISTED columns.
SQL SERVER – Computed Column – PERSISTED and Storage – Part 2
Part 2 of my look at the computed column and its effect on storage, with a list of the earlier articles in the series on PERSISTED storage and performance.










