Home Forums Article Discussions Article Discussions by Author Discuss content posted by bitbucket T-SQL Performance 1 RE: T-SQL Performance 1

  • February 17, 2012 at 2:08 am

    #1448325

    handkot (2/17/2012)

    offtop

    The performant alternative:

    Create a Tally or Numbers Table

    create table dbo.Tally(i int identity(1,1))

    go

    insert into dbo.Tally DEFAULT VALUES

    go 1000000

    You're still performing a loop, aka RBAR (row by agonazing row).

    The Tally Table from Jeff executes in less than a second, while this little loop executes for over 1 minute on my machine (see attachment). And I changed the code to 11000, I wouldn't like to know what happened if I kept 1000000.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP