A short pattern can run a long CPU bill. Here is why REGEXP_LIKE scans, and how a plain prefix filter gives the index something to seek.
Unicode Lost: Finding Question Marks Left by varchar Conversion
Customer names turn into question marks, and an nvarchar column does not bring them back. Here is how it happens and how to repair it.
UNISTR and Unicode Escapes in SQL Server 2025
Build Unicode strings with UNISTR in SQL Server 2025, compare NCHAR, and preserve accented letters, Hindi text, and emoji in storage.
Sizing nvarchar Columns: How Long Should a Name Be?
A name fits the web form but fails in the table. Measure real lengths in characters and bytes before you choose a size.
Agent Tokens in Job Steps: Job Name, Step and Start Time
A copied job should log its own name, not the old one. Agent tokens do that, if you escape them the right way.
Case-Insensitive and Multiline Regex Flags in SQL Server 2025
Your pattern passed the test string and then missed rows in the table. The flags and the line endings are the usual reason.
Generating Unique, Hard-to-Guess Voucher Codes in T-SQL
Random-looking codes can still be guessed. Build 20 voucher codes from random bytes, check them, and make redemption single-use.