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


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


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

Always On: Troubleshooting Consolidated


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

Changing Git Credentials in Windows


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

Read the latest Blogs


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


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

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers