SQL Sentry's Aaron Bertrand (@AaronBertrand) shows how you can use Extended Events to track temp table creation and identify which session created which #temp table.
Erin Stellato (@erinstellato) of SQLskills walks through three methods of tracking automatic statistics updates: SQL Trace, Extended Events, and dynamic management objects.
