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,221 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)
13,555 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)
11,181 reads
2017-09-11
1,273 reads
Blogs
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
What is Always Encrypted and how does it work?
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
Power BI – Empowering Users to Disable Tooltips
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Forums
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC