Use Central Management Servers and registered servers in SSMS to organize SQL Server instances and run safe read-only queries across groups.
Finding Single-Use Plans Wasting Memory in the Cache
Find single-use plans, compare their cache memory with the total, and inspect parameterization before discussing server-wide cache settings.
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.