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 (180)

2012-12-28 (first published: )

74,185 reads

Blogs

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

Failed to installing Failover Cluster

By Nivs719

Hello everyone, I Have SQL Server 2017 Developer edition, Windows 10, and I'm trying...

Storing JSON data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Storing JSON data

Memories of DR testing

By MVDBA

Comments posted to this topic are about the item Memories of DR testing

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers