Home Forums SQL Server 2008 SQL Server 2008 - General How to replace null value in a query RE: How to replace null value in a query

  • August 11, 2014 at 2:15 am

    #1736710

    New_2SQL (8/10/2014)

    Hi Jeff Moden,

    This was a test run on about 88 rows as you can see in the source code posted above.

    During production rows will grow in millions.

    If production conditions qill have to deal with millions of rows, your test setup should reflect that.

    I strongly recommend to test against a million row table.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]