Tally Table

SQLServerCentral Article

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.83 (188)

2012-12-28 (first published: )

115,201 reads

Blogs

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

need some help in tweaking a query

By bobrooney.81

Hi All, I am looking for some tsql help. I am from Oracle background....

SQL Server 2017 AlwaysON Secondary Replica use case

By vsamantha35

Hi All, I need some advice on Always on secondary replica usage. We are...

DENSE_RANK different sequences

By vilaca

Hi all, I have this data: Code               ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers