Archive for December, 2015

performance tuning note

December 8, 2015

dont forget pivots and recursive cte’s are great on small datasets but they dont scale well

  • pivots can be replaced with joins and case statements
  • recursive cte’s can be replaced with while loops and insert statements
Advertisements