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

Blogs

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

By

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

The Gift of the SPN

By

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

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

By

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

Read the latest Blogs

Forums

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

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers