• Gianluca, my ol' and trusted friend,

    Very nice and well written article with lots of well fomatted, easy to read, documented code. Nicely done.

    Shifting gears, I have a couple of questions, please.

    1. What is the configuration and speed of the computer you did the testing on?

    2. Which edition and version of SQL Server and Windows did you run your tests on?

    3. When you did your duration testing, where did you have the result set return to? A table? Grid mode on the screen? A throw-away variable? or ???

    4. When you did your duration testing, how did you measure the duration? STATISTICS TIME ON? SQL Profiler? or ???

    5. When you did your duration testing, what was the configuration of your test table? Single column of dates? Indexes or not?

    6. Is there any chance of you attaching your test data generator and your test harness to this thread so I can make sure that my testing is done the same way you did it?

    7. Since I don't even know how to spell C#, would it be possible for you to script the CLR assembly out in a "Paul White" fashion so that I could install it on my machine for a little testing of my own?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)