Pattern Matching : More Fun When I Was a Kid
Aaron Bertrand runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.
2016-10-05
3,387 reads
charindex
2013-05-21
2,185 reads
Find the position of all occurrences of an expression within a string
This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.
2015-05-12 (first published: 2013-03-24)
2,135 reads
Blogs
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Daily Coping 24 Mar 2023–The Final Tip
By Steve Jones
Today’s coping tip is to discover the joy in the simple things in life....
Forums
SQL Agent jobs - script to get what jobs failed
I have been trying to find SQL that shows what SQL Agent jobs failed...
Need help desperately
I accidentally ran this on a dev server which has locked my acct and...
Slow performance when processing a JSON file in Azure
We have a stored procedure that can load up a JSON file and process...
Ask SSC