Running out of drive space is a common reason SQL Server stops. sp_spaceused shows the Space Used by any table, with its row count and index size.
Trigger Overhead: Measuring the Hidden Cost of DML Triggers
Measure trigger overhead with controlled inserts, execution plans, and cached trigger statistics before moving slow work into a queue.
Parameterized Queries From Application Code
Use parameterized queries from application code to prevent SQL injection, improve plan reuse, and avoid parameter length mistakes.
DATEPART Quarter: Keep the Year Beside the Quarter
DATEPART quarter identifies a calendar component. I keep its year when reporting separate periods. A cross-year January case shows how quarter-only grouping combines events.
A One Page Reference for Everyday SQL Server Work
Build a practical SQL Server reference around everyday questions, with compact queries for context, objects, requests, space, and transactions.
Finding Dynamic SQL Open to Injection
Find dynamic SQL open to injection by searching module definitions for concatenation, then replace data concatenation with parameters.
Reading SQL Server Release Notes Before You Patch
Reading SQL Server Release Notes before patching helps you find known issues, fixes, behavior changes, and workload risks.