Post reply

T-SQL Greatest function workarounds - timing tests

  • May 1, 2013 at 1:37 am

    #1611481

    Evil Kraig F (4/30/2013)

    Mark-101232 (4/30/2013)

    Results from 2012 SP1

    Cascade Test131824601220

    CASE Test123823501150

    Values Test6011016503

    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)

    TestSourceTestTypeAvgLenMaxLenMinLenCountOfEntries

    No Case CheckCascade Test67487052350

    No Case CheckCASE Test54072339350

    No Case CheckValues Test38451028650

    Static DatesCascade Test1106225079350

    Static DatesCASE Test952149681050

    Static DatesValues Test49055036650

    Variable DatesCascade Test974113067050

    Variable DatesCASE Test80696657350

    Variable DatesValues Test48658041050

    ____________________________________________________

    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 15 total)

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