Tidbits

Pre-filtering large datasets

When dealing with missing indexes or large data sets across joins, in-memory temp tables are often be a highly performant solution.