Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.
2019-08-13 (first published: 2019-08-04)
7,661 reads
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)
418 reads
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,867 reads
2016-04-01 (first published: 2016-03-23)
856 reads
2013-06-13 (first published: 2013-05-30)
3,041 reads
The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).
2012-12-28 (first published: 2011-05-02)
140,913 reads
In part II of this series, Sioban Krzywicki shows us another way Tally Tables have helped solve problems - Text Parsing.
2010-08-03
9,326 reads
In the first part of a series on Tally Tables, Sioban Krzywicki shows how a Tally Table has helped out with fiscal year calculations.
2010-08-02
16,328 reads
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
Comments posted to this topic are about the item Getting the Schema for Tables
Comments posted to this topic are about the item An Unexciting Exciting Release
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers