GetNumsAB
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2020-07-02 (first published: 2016-03-23)
1,180 reads
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2020-07-02 (first published: 2016-03-23)
1,180 reads
An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.
2018-11-22 (first published: 2016-06-23)
12,949 reads
Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+
2018-01-05 (first published: 2016-06-07)
10,740 reads
2017-09-11
1,271 reads
By Steve Jones
The grade for January is a D. Details below, but just not making a...
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
This isn't* specific to 2022, but SQL in general. I will be joining a...