A Trio of Functions
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me some interesting things I had never really paid much...
2012-01-17
7 reads
Blog Posts
ColoradoSQL for January 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-01-17
564 reads
CTE command In Sql Server
Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by...
2012-01-17
4,982 reads
Eliminating Successful Backup messages with Powershell and SMO
As a DBA, I enjoy knowing that the better job I do, the less likely it is that any of...
2012-01-17
935 reads
Error when creating a subscription
When creating a subscription in SQL Server sometimes the following error will occur:
The remote server "%s" does not exist, or...
2012-01-17
1,908 reads
Free SQL Performance Tool Worth Checking
First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur). This is...
2012-01-17
1,625 reads
Goals – 6 month checkup
Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself...
2012-01-17
821 reads
Hungarian Notation is misunderstood
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
980 reads
Missing Indexes
SQL Server has means built into it to track possible missing indexes. This used to be found through the use...
2012-01-17 (first published: 2012-01-12)
3,824 reads
PASS Data Architecture VC presents: Audrey Hammonds–Database Makeover: Renovate Your Data Model
Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011...
2012-01-17
492 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...
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