Return codes carry procedure status separately from application values. This private demonstration compares result sets, captured output and omitted OUTPUT. It also separates an optional no-work request from a genuine raised error.
Monitoring Log Growth and VLF Counts
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.