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)
5,280 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)
6,456 reads
2017-09-11
1,246 reads
Blogs
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
What's New in SQL 2019? at BRSSUG
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Forums
Using crypt_gen_random to generate unique Serial Numbers
Trying to generate unique serial numbers with alphanumerics (A-Z,a-z,0-9) and no special characters.Used below...
OPENQUERY is not inserting identical rows
Hi, Thanks in advance for any help. I am trying to insert into a...
Azure file copy creating a directory to hold the renamed file
Hi All, I'm pretty new to azure and am hitting the following problem. I've...
Ask SSC