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
Alan Burstein
- Interests: Text Mining, T-SQL, SQL, XML, XSLT, MDX, Brazilian Jiu Jitsu
Nasty Fast N-Grams (Part 1): Character-Level Unigrams
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
Nasty Fast PERCENT_RANK
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
Blogs
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Introducing… Data On Rails!
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
Forums
"ID" primary key from two separate tables as a foreign key in a new table
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
blocking issue
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Identity column and "EntityID" column naming convention
This isn't* specific to 2022, but SQL in general. I will be joining a...
Ask SSC