Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins.Before we start Adaptive Joins, SQL Server's Query...
2017-11-29
59 reads
Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins.Before we start Adaptive Joins, SQL Server's Query...
2017-11-29
6 reads
I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Unfortunately though, I think a lot...
2017-11-29 (first published: 2017-11-20)
1,396 reads
Encryption has always been intriguing to me but seemed like it could be a very complex process to set up....
2017-11-29
1,314 reads
I wrote a post over on the dbatools website about how to get involved with improving comment-based help
Working on the CBH is a great way to get started with...
2017-11-29
3 reads
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
701 reads
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...
2017-11-29
771 reads
One of the ways that I try to keep current and learn is through Pluralsight. I’m lucky to get a...
2017-11-29
1,204 reads
This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login...
2017-11-29
612 reads
I’ve been writing crosswords for the last few months and to change things up I thought I would do a...
2017-11-29
560 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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