Tally Table

Tally OH! An Improved SQL 8K “CSV Splitter” Function

  • Article

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).

4.82 (181)

2012-12-28 (first published: )

80,373 reads


Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020


Are you a speaker in SQL Server topics? Come on out to Richmond, VA...

The Gift of the SPN


Every once in a while there is an extremely valuable tool that comes along....

T-SQL Tuesday #121: Gifts received for this year


It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the...

Read the latest Blogs


Verify your SQL Server database backups

By Steve Rezhener

Comments posted to this topic are about the item Verify your SQL Server database...

weird sql problem.

By mig28mx

Hi all, I´m not sure what I´m doing bad with this query: Situation: I...

can I use Stretch database to migrate the database to azure.

By goher2000

HI Guys,   can I use Stretch database to migrate the database to azure.?...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers