Indexed view deadlocking
Deadlocks can be a really tricky thing to track down the root cause of. There are lots of articles on...
2012-06-22 (first published: 2012-06-13)
3,819 reads
Blog Posts
Is That Your Code? [Copyright Considerations]
Think about that last SQL statement that you wrote. Did you originally write it? Are you sure you wrote it? ...
2012-06-22
1,289 reads
Presenting at PASS Summit 2012
I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”. I...
2012-06-22
522 reads
Speaking at SQL Saturday 159 in Kansas City!
Come to Kansas City on August 4th for SQL Saturday 159 and hear us speak!
At 2:30pm, I will be speaking...
2012-06-22
608 reads
SQL Saturday Dallas–BI Edition (again!)
I’m happy to announce that the North Texas SQL Server User Group will be hosting our fourth SQL Saturday event...
2012-06-22
406 reads
SQL Saturday Dallas–BI Edition (again!)
I’m happy to announce that the North Texas SQL Server User Group will be hosting our fourth SQL Saturday event...
2012-06-22
723 reads
Back From Vacation
As you may surmise from my previous post I’m back from vacation. I was as unplugged as I’ve been in...
2012-06-21
564 reads
I’m Speaking At PASS Summit 2012
With the release of the PASS Summit 2012 schedule, I’m pleased to announce that I have been selected to present...
2012-06-21
827 reads
Live note-taking: Sean’s NCC-1701-DBA part 2
Note that THIS talk, and a ton more, is the subject of Sean’s precon at SQL Saturday #163 Dallas this...
2012-06-21
938 reads
PASS SQLSaturday - July Events
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2012-06-21
760 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Forums
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
Question of the Day
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