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,409 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)
15,973 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)
13,100 reads
2017-09-11
1,313 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU PURI INDAH Telpon/WA:08213111185
BCA KCU PURI INDAH Telpon/WA:08213111185 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya...
BCA KCU WISMA ASIA Telpon/WA:08213111185
BCA KCU WISMA ASIA Telpon/WA:08213111185 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota...
BCA KCU DAAN MOGOT Telpon/WA:08213111185
BCA KCU DAAN MOGOT Telpon/WA:08213111185 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers