Does The Order Of Index Columns Matter?
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance...
2018-09-13 (first published: 2018-09-04)
5,016 reads
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance...
2018-09-13 (first published: 2018-09-04)
5,016 reads
This post is a response to this month's T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-09-11
5 reads
This post is a response to this month's T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-09-11
5 reads
Watch this week’s episode on YouTube.
Last week I needed to write a recursive common table expression. I’ve written them before,...
2018-09-07 (first published: 2018-08-21)
2,336 reads
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
3 reads
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
6 reads
This post is a response to this month’s T-SQL Tuesday #105 prompt by Wayne Sheffield. T-SQL Tuesday is a way...
2018-08-30 (first published: 2018-08-14)
3,823 reads
Watch this week’s episode on YouTube.
The SQL Server FIRST_VALUE function makes it easy to return the “first value in an...
2018-08-28
8,864 reads
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
11 reads
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
13 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...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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