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)
16,042 reads
Alan Burstein
- Interests: Text Mining, T-SQL, SQL, XML, XSLT, MDX, Brazilian Jiu Jitsu
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)
13,127 reads
2017-09-11
1,314 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)
1,411 reads
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
ALAMAT BCA KCU KUNINGAN Telp 08218200174
Via WhatsApp+62 821-8200-174 Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Jl....
ALAMAT BCA KCU PURI INDAH Telp 08218200174
Via WhatsApp+62 821-8200-174 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk...
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers