Use realistic data and workload tests to evaluate a database, checking correctness, latency, recovery, compatibility, and the full operating cost.
Insert Multiple Rows in SQL Server: SQL in Sixty Seconds #024
To insert multiple rows in SQL Server, use separate INSERT statements, UNION ALL or one VALUES list. The tests here compare all three on SQL Server 2025, including failures, the 1,000 row limit and the time for 1,000 rows.
SQL SERVER – A Brief Note on SET TEXTSIZE
Is there any difference between the LEFT function and SET TEXTSIZE? A quick script shows how each one trims a long VARCHAR(MAX) value in the results.
What to Collect When SQL Server Is Slow
Collect SQL Server diagnostic data in a useful order: waits, active requests, blockers, execution plans, and file IO during the slow period.
REGEXP_COUNT in SQL Server 2025: Counting Pattern Matches in Text
REGEXP_COUNT counts how many times a pattern matches inside a text value, a job that used to need LEN and REPLACE tricks. This post tests it on SQL Server 2025: start position, flags, NULL and empty text, a data quality check, and where the old trick still fits.
SQL SERVER – Color Coding SQL Server Management Studio Status Bar – SQL in Sixty Seconds #023 – Video
Color code the SQL Server Management Studio status bar so you always know which server you are on before you run a script. A quick video.
Non-Updating Updates: Skipping Rows That Would Not Change
An UPDATE that writes the same value still marks the row as modified. I show how IS DISTINCT FROM skips those rows and keeps NULL changes.







