I'm new...
I've built an ETL process in SSIS that takes 46 flat files and loads them into stg.Suppliers and triage.Suppliers. Then another solution runs that applies Business Rules. And then the final solution moves the good stuff from stg.Suppliers into pdw.Suppliers.
My question is when I run all this (once a week); is it good (best practice) to clean up the buffer for the stg.Suppliers table? I notice that when I run this query that it's the number one cached_pages_count.
If yes, how?