Home Forums SQL Server 2008 T-SQL (SS2K8) Addition Of Digits RE: Addition Of Digits

  • August 6, 2012 at 4:18 am

    #1521943

    Cadavre,

    Thx for the testing scripts! Especially pointing a bug with replace function (closed as by design).

    I have quite similar results

    ========== SomewhereSomehow ===========================================

    SQL Server Execution Times:

    CPU time = 19813 ms, elapsed time = 5501 ms.

    ========== CELKO ===========================================

    SQL Server Execution Times:

    CPU time = 20437 ms, elapsed time = 20529 ms.

    ========== Mark =====================================================

    SQL Server Execution Times:

    CPU time = 12891 ms, elapsed time = 3846 ms.

    ========== IMPROVED CELKO ===========================================

    SQL Server Execution Times:

    CPU time = 2859 ms, elapsed time = 2853 ms.

    I am really sorry for my poor gramma. And I hope that value of my answers will outweigh the harm for your eyes.
    Blog: http://somewheresomehow.ru[/url]
    Twitter: @SomewereSomehow