How explicitly insert default value ? TIP #72
Suppose, sometimes you just need entry in the table with all the default values.
For example you have a Student...
2014-11-10
210 reads
Blog Posts
Last Weeks Top “Reading” Links #108
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-10
330 reads
Let’s get started
Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...
2014-11-10
474 reads
Monitoring BI Performance: Scripts and Slides
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...
2014-11-10
1,245 reads
PASS Keynote–Dr. Rimma Nehme
I missed the PASS welcome, but I did arrive to see Cloud Databases from Dr. Rimma Nehme.
We begin with a...
2014-11-10 (first published: 2014-11-06)
5,324 reads
PASS Summit 2014: WIT Luncheon with Kimberly Bryant
Kimberly Bryant, founder of Black Girls Code
When Kimberly Bryant began studying programming at college, she found that there were few...
2014-11-10 (first published: 2014-11-06)
4,182 reads
Summit 2014
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS...
2014-11-10
465 reads
How to pause execution for particular time or interval ? TIP #71
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...
2014-11-09
284 reads
SQL PASS 2014 Summit Diary – Day 6
Today is the last official day of the PASS Summit. The sessions will wrap up at the end of the...
2014-11-08
847 reads
Working with Very Large Tables Like a Pro in SQL Server 2014
I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....
2014-11-08
1,038 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...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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