Convert currency strings into decimal amounts using known symbols, explicit parsing cultures, conversion checks, and rejection evidence.
SQL SERVER – A Comparison of CHARINDEX vs LIKE
In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
Materialized Path Hierarchies: Storing the Path as a String
Build a materialized path hierarchy in T-SQL, query descendants, calculate depth, and move a subtree without creating cycles.
SQL SERVER – STRING_AGG Function to Concatenate Strings
We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn.
SQL SERVER – Replacing a Cursor with a Common Table Expression
Let us learn today – How I was able to improve the query performance by replacing the cursor with a common table expression (CTE).
EDIT_DISTANCE and JARO_WINKLER: Fuzzy String Matching in SQL Server 2025
EDIT_DISTANCE counts the single-character changes between two strings, and the JARO_WINKLER functions score how alike they look. This post tests the four preview functions on SQL Server 2025, shows the Windows collation error and its fix, and finds near-duplicate customer names.
Case-Sensitive Search – SQL in Sixty Seconds #158
Earlier I wrote a blog post about SQL SERVER – Case-Sensitive Search. Lots of people said I should make a video on this topic.