http://www.sqlservercentral.com/Articles tagged Numbers Table posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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).

]]>http://www.sqlservercentral.com/articles/Tally+Table/72993/Fri, 28 Dec 2012 07:00:00 UThttp://www.sqlservercentral.com/articles/Tally+Table/72993/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).

]]>http://www.sqlservercentral.com/articles/Tally+Table/72993/Fri, 28 Dec 2012 07:00:00 UThttp://www.sqlservercentral.com/articles/Tally+Table/72993/