Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...
2015-10-19
4 reads
Join PernixData and me tomorrow at 1PM Pacific for a webinar discussing an exciting technology from PernixData!
In-memory computing is gaining...
2015-10-19
306 reads
Continuation from the previous 68 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is dedicated to one of...
2015-10-18
525 reads
Dear Friends,
This is another post in the series of step by step SSIS ,Zero to hero series. In this post...
2015-10-18
2,791 reads
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-10-18
379 reads
To celebrate a recent achievement, I have decided to create a whole new section to my blog that will be...
2015-10-17
503 reads
Thanks for attending my session on analyzing data with TSQL. I hope you learned something you can take back and...
2015-10-17
525 reads
Dear All,
In the series of zero to hero SSIS series this is one of the simplest transformation control which...
2015-10-17
1,117 reads
Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how...
2015-10-16
456 reads
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
187 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Comments posted to this topic are about the item Doing Good at SQL Server...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers