Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to handle very large dataset RE: How to handle very large dataset

  • February 26, 2018 at 12:40 pm

    #1981174

    NineIron - Monday, February 26, 2018 12:00 PM

    See attached.

    "idx_income" is an odd name for a heap! Why don't you have a clustered index? What's the purpose of this table? What's its daily/weekly cycle of changes?
    And what Jeff said too - this is wildly different from your trivial original query.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]