Using a Staging Environment for Tracking Down Bugs
A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.
Being able to...
2011-06-08
2,137 reads
Using Nightly Populated Tables For Faster SQL Queries
A discussion about nightly populated tables and how they have reduced SQL Server load.
What’s more important – speed or data accuracy/quality...
2011-06-05
1,293 reads
Avoiding OR Conditions with Joins
Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just...
2011-06-03
2,810 reads
SQL Exercise During Candidate Interview Process
A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...
2011-06-01
2,710 reads
SQL Query Run Time Estimation
A followup to a post about subqueries with an estimation for how long it would take for the query to...
2011-05-30
3,425 reads
Using Views for Faster SQL Query Development
A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...
2011-05-28
844 reads
Random Ordering of Results using NEWID
A discussion of how NEWID can be used to help randomize the results returned from a SQL query.
A scenario I...
2011-05-26
1,145 reads
Efficiency of Subqueries and OR conditions in SQL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...
2011-05-25
949 reads
Double digits in posts!
Thank you to everyone reading this site - Please enjoy your stay!
HelpWithSQL has hit double digits in posts! I hope everyone...
2011-05-24
616 reads
SQL Joins and Subqueries
A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...
2011-05-22
1,105 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