Find single-use plans, compare their cache memory with the total, and inspect parameterization before discussing server-wide cache settings.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
REGEXP_MATCHES: Read Matches and Capture Groups
REGEXP_MATCHES returns full matches and captured groups. Read group values and positions, preserve duplicate letters, and check a no-match input.
LIKE ESCAPE: Search for a Literal Percent Sign
LIKE ESCAPE expresses a literal punctuation search. Preserve the distinction between wildcard pattern instructions and stored text.
SQL Server Express Limits: A Complete Reference Guide
SQL Server Express limits depend on the version you install. This guide lists the database size limits for 2008, 2022 and 2025, and gives tested queries to check the edition, the allocated data space, the free headroom and a verified backup.
ISO Week Numbers vs DATEPART(week): Grouping Sales by Week
Group sales by ISO week and ISO year, compare DATEPART week behavior, and avoid New Year errors caused by session settings.
SQL SERVER – Index Seek vs. Index Scan – Difference and Usage – A Simple Note
Index seek vs. index scan: the two ways SQL Server reads data through an index, how they differ, and when each one is used. A simple note.
Raising a Database Compatibility Level Safely
Raise a compatibility level safely by capturing a Query Store baseline, changing one database, comparing plans, and keeping a tested reversal.
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.