Introduction to STRING_SPLIT function in SQL
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
10,391 reads
T-SQL
2020-03-02
829 reads
Mean Median Mode using SQL and DAX
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
2020-02-28
34,296 reads
2020-02-27
23,423 reads
2020-02-27
724 reads
Introduction to Indexed Views in SQL Server
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
2020-02-25
21,796 reads
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
88,621 reads
Handling Aggregations on a Poorly Designed Database
When the database design is not great, you may have to write some creative queries to get what you need.
2020-02-17
3,462 reads
2020-02-14
889 reads
A quick search without an index
Alex Chamchourine explains how he managed to find a row in a billion row table without an index.
2020-02-14
8,054 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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
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...
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