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,208 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,242 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kertosono No tlpon:083138717148
Whatsapp:083138717148.Jl. Ahmad Yani No.114, Kutorejo, Kec. Kertosono, Kabupaten Nganjuk, Jawa Timur 64313
BCA KCP Juanda MedanTelepon 083110611866
WhatsApp 083110611866Jl. Ir. H. Juanda No.28, Suka Damai, Kec. Medan Polonia, Kota Medan, Sumatera...
BCA KCP Ternate Telp:cs.(0821)8171955
Whatsapp:08218171955 Jatiland Mall Ruko A1, A2 dan A3 Jl. Sultan Iskandar Muhammad Djabir Syah,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers