Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating correlation, regression and variance on large quantities of data. It just isn't always immediately obvious how. In the second of a series of articles, Phil factor shows how calculating a non-parametric correlation via Kendall's Tau or Spearman's Rho can be stress-free.
2017-06-20
3,513 reads
SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.
2017-06-19
1,164 reads
What is normal? More to the point, what is abnormal? We will look at using R to score outliers in a typical monitoring dataset.
2017-06-19
4,090 reads
2017-06-16
2,562 reads
Your SQL Server drives are running out of disk space and you want a way to quickly tell which sub-directories are taking the most space - here's how to do it with T-SQL.
2017-06-16
4,950 reads
Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.
2017-06-15
2,262 reads
Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.
2017-06-15
3,969 reads
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
2017-06-14
4,088 reads
How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.
2017-06-13
1,806 reads
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.
2017-06-13
5,896 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...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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