T-SQL Greatest function workarounds - timing tests

  • Mark Cowne

    One Orange Chip

    Points: 26743

    Evil Kraig F (4/30/2013)


    Mark-101232 (4/30/2013)


    Results from 2012 SP1

    Cascade Test 1318 2460 1220

    CASE Test 1238 2350 1150

    Values Test 601 1016 503

    Appreciate the time Mark. Would you be willing to rerun with the harness in the fourth post? After Mr. Magoo brought up a few things I expanded the harness.

    Running on SQL Server 2012 SP1 Standard Edition (64-bit)

    TestSource TestType AvgLen MaxLen MinLen CountOfEntries

    No Case Check Cascade Test 674 870 523 50

    No Case Check CASE Test 540 723 393 50

    No Case Check Values Test 384 510 286 50

    Static Dates Cascade Test 1106 2250 793 50

    Static Dates CASE Test 952 1496 810 50

    Static Dates Values Test 490 550 366 50

    Variable Dates Cascade Test 974 1130 670 50

    Variable Dates CASE Test 806 966 573 50

    Variable Dates Values Test 486 580 410 50

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply