SQLskills is recording their knowledge in conjunction with Pluralsight for you to view from the time and place of your choosing. And it's free in September. Read more to find out how you can get access.
2012-09-10 (first published: 2012-09-05)
6,654 reads
This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.
2012-09-07 (first published: 2011-02-28)
35,560 reads
Having shown just how useful PowerShell can be for DBAs in executing queries, Michael Sorens now takes us through navigating SQL Server space and finding meta-information - valuable information for anyone looking to be more productive in SQL Server.
2012-09-07
2,770 reads
Southern California isn't all beach time. SQL Saturday comes to San Diego on Sept 15, 2012. Join fellow SQL Server pros for a day of learning.
2012-09-07 (first published: 2012-08-15)
2,069 reads
Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables
2012-09-06
17,439 reads
How can I find out which statistics are outdated in my SQL Server database?
2012-09-06
3,505 reads
Come to Cambridge in the UK for a free day of training on SQL Server. Steve won't be there, but plenty of other Red Gate'ers will be.
2012-09-06 (first published: 2012-08-07)
3,041 reads
Having finally got around to upgrading my custom components to SQL Server 2012, I thought I’d share some notes on the process. One of the goals was minimal duplication, so the same code files are used to build the 2008 and 2012 components, I just have a separate project file.
2012-09-05
2,194 reads
This article discusses failover cluster instances and AlwaysOn groups
2012-09-04
12,390 reads
Free SQL Server training comes to Germany. Join fellow SQL Server pros in Munich on Sept 15, 2012.
2012-09-04 (first published: 2012-08-14)
1,993 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...
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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