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)
7,404 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,882 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)
824 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server 2016 seeding automatic stuck
Hi all, Problem help please, I have 2 servers in sql server 2016 and...
will this get replicated to secondary replica
Dear Experts, In Availability Group, if we move ndf file to another drive on...
slow query performance
Hi All, I have a SELECT query which is taking more 8 mins. Can...
Ask SSC