Rewriting Queries with Temporary Staging Tables
Sometimes SQL Server doesn't reuse your filtered and transformed datasets, causing a large amount of unnecessary reads. In this episode we look at a technique for helping SQL Server reuse filtered data in your queries.
Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/DataWithBer...
Related blog post with example code:
https://bertwagner.com/2019/05/07/tem...
Follow me on Twitter:
/ bertwagner
