• GilaMonster (8/31/2013)


    Google: tally table (or dates table maybe)

    +100

    What kills you the way you are doing it is log buffer flushes. Google them too if you are interested. Tally table is also known as a numbers table, and there are a number of articles about what you can do with them here. Jeff Moden is a primary author to seek out. I think he also has an article here on SSC.com using them to generate test data, which would definitely be helpful for you to review as well.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service