Running Total Performance

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  April 7, 2015 at 12:41 am

  #1789102

  Kathi Kellenberger (4/4/2015)

  ---

  There are a few things, such as creating a custom window aggregate function.

  With CLR?

  Kathi Kellenberger (4/4/2015)

  ---

  Itzik's book spends a lot of time talking about theoretical functionality that I don't.

  Ah yes, skipped that chapter on the second read.

  Kathi Kellenberger (4/4/2015)

  ---

  I also have a great chapter written by BI guru Clayton Groom that shows how to use window functions instead of SSAS cubes. My teaching style is different than Itzik's as well.

  That seems very interesting. I'll read your book

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP