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 7:16 am

    #1736845

    LutzM (8/11/2014)

    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.

    And at that point I would hope that you are restricting the query with a WHERE clause to limit the data being processed.