Execution Plans in Extended Events
Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both...
2015-06-17
1,130 reads
Jason Brimhall
Execution Plans in Extended Events
Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both of these tools are fantastic for troubleshooting. Combined,...
2015-06-17
11 reads
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive (yes I am calling...
2015-06-15
4 reads
Extended Events, Birkenstocks and SQL Server
I bring you yet another installment in the monthly meme called T-SQL Tuesday. This is the 67th edition, and this time we have been given the opportunity to talk...
2015-06-10
3 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when a database is “In Recovery”. When I pulled that...
2015-05-18
5 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when...
2015-05-18
483 reads
Monitoring SQL Server
Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related...
2015-05-12
554 reads
Monitoring SQL Server
Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related meme in the blogosphere – TSQLTuesday. This month we...
2015-05-12
4 reads
2015-05-11
1,599 reads
Audit who Dropped the Database
In the first article on this topic (which can be read here), I discussed the problem of having a database...
2015-04-15 (first published: 2015-04-07)
4,743 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