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)
6,932 reads
Alan Burstein
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)
7,564 reads
2017-09-11
1,254 reads
GetNumsAB
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2016-04-19 (first published: 2016-03-23)
805 reads
Blogs
Social: Going Along to Get Along
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
Daily Coping 3 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using Docker Volumes for SQL Server in Linux
By John
No, not that kind of volume! Over the past couple of blog posts, I...
Forums
stored procedure to delete user and login
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Managing Stress
Comments posted to this topic are about the item Managing Stress
Failover Cluster Instance Share
Hi, I am using AlwaysOn Availability Groups in SQL Server 2016 with a primary...
Ask SSC