Generating n-Tuples with SQL
An n-Tuple is a combination of values from rows of a table in pairs (2-Tuple) or triplets (3-Tuple), etc.
Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass
A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.
Stop Asking and Start Making Decisions Today
You’re desperately trying to get things done but it’s just not happening for you. I’m going to let you in on a little secret, you’re doing it wrong!
The Real World: Implementing AWE
Describes the gains experienced in my environment by implementing AWE.
What is Big Data?
The definition of Big Data is rather murky, despite all the press and attention given to it. Steve Jones talks about what Big Data means for relational databases.
How to Create an Indicator and Gauge Report in SSRS - SQL Server 2008 R2 - Part 1
Arshad Ali discusses the details of creating reports with indicators and gauges in SQL Server 2008 and walks you through designing a one tablix report with two levels of grouping.
Self Service SQL
Self service in IT is something Steve Jones likes, but it doesn't solve all problems, and might end up creating more issues.
Partial Backup and Restore
Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.
PASS Data Architecture VC presents Mike Fal on Eating the Elephant: SQL Server Table Partitioning
On Thursday May 17th 12PM noon Central, Mike Fal will discuss "SQL Server's table partitioning gives the DBA tools to manage this beast and support very large tables in a way where index management and data retrieval..."
A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
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