To find rows with single quotes, write the quote twice inside the search string. This post tests four search patterns on one million rows on SQL Server 2025, shows which two are the same query and which one costs more, and covers the curly quote that a straight quote search misses.
REGEXP_LIKE Performance: Why Pattern Filters Cannot Seek
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.