What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
1,623 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
175 reads
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek on indexes. The term’s an abbreviation, ‘SARG’ stands for...
2016-09-13
8 reads
SQL Server 2016 features: R services
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen...
2016-05-24
733 reads
SQL Server 2016 features: R services
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen...
2016-05-24
227 reads
SQL Server 2016 features: R services
One of the more interesting features in SQL 2016 is the integration of the R language. For those who haven’t seen it before, R is a statistical and data...
2016-05-24
10 reads
Boundless Opportunities
There has never been more reasons or better opportunities to learn new skills. Gail Shaw shares her favorite online video training resources sites, what's on her current learning list and why.
2016-05-23
162 reads
SQL 2016 features: Stretch Database
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows...
2016-04-29 (first published: 2016-04-19)
2,659 reads
Upcoming conferences
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
867 reads
Upcoming conferences
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
386 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
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