SQL Server – How to troubleshoot query timeouts
Common reasons for query time-outs are :
1) The application starts using a query not optimal for the index
2) Hardware changes\...
2012-03-04
4,386 reads
Blog Posts
A Script A Day Finished!
Well that's it, my "A Script A Day" series is finished. I hope you found the scripts I provided useful, I've used...
2012-03-03
570 reads
Goodbye Microsoft, Hello World
Goodbye Microsoft, Hello World
Goodbye Microsoft, Hello World
The cowboy’s job is done here, and it’s time for him to move on...
2012-03-03
2,017 reads
Low Power SQL Server Test Lab on Windows Server 8 Hyper-V / ESXi5
Windows Server 8 Beta is released, if you are looking to build a low cost, Low power PC which can...
2012-03-03
993 reads
2012-03-03
7 reads
2012-03-03
16 reads
2012-03-03
7 reads
2012-03-03
11 reads
SSRS or a Custom Web Form – Pros & Cons
In response to a post I made on an unrelated topic, a reader said "I’m not really a fan of...
2012-03-03
996 reads
A Script A Day - Day 28 - String Manipulation
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200...
2012-03-02
523 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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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