Home Forums Article Discussions Article Discussions by Author Discuss content posted by Paul White Understanding and Using APPLY (Part 2) RE: Understanding and Using APPLY (Part 2)

  • January 31, 2012 at 10:02 am

    #1440783

    peter-757102 (1/31/2012)

    I did check some on the net myself (long live Google)....and this is what I get from it:

    I guess another consideration might be what to use as the clustering key, how wide that would be (which would affect nc indexes too), and whether having to sort new data in order of the cluster would be expensive or not.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi