In this video, I show how we can use the APPLY operator to operate on ad hoc functions. That leads to a powerful use case: pre-aggregating data.
Every once in a while, this tip will save a considerable amount of CPU time and database effort.
A Fine Slice Of SQL Server
In this video, I show how we can use the APPLY operator to operate on ad hoc functions. That leads to a powerful use case: pre-aggregating data.
Every once in a while, this tip will save a considerable amount of CPU time and database effort.