Jeff Moden

  • Interests: SQL. When Im not having fun with that, then SQL. ;-)

SQLServerCentral Article

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

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

You rated this post out of 5. Change rating

2012-12-28 (first published: )

133,950 reads

SQLServerCentral Article

Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?

4.93 (29)

You rated this post out of 5. Change rating

2012-11-15

18,612 reads

Blogs

What to Know about Power BI Theme Colors

By

Power BI reports have a theme that specifies the default colors, fonts, and visual...

A Global Team Meeting

By

The last few years at Redgate we’ve had the entire (or most) of the...

A New Word: sayfish

By

sayfish – n. a sincere emotion that seems to wither into mush as soon...

Read the latest Blogs

Forums

What Do You Want to Learn?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What Do You Want to...

How to Rename a Column in SQL Server

By Nisarg Upadhyay

Comments posted to this topic are about the item How to Rename a Column...

Disable Memory Grant Feedback Persistence

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Disable Memory Grant Feedback Persistence

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers