It's surprising how many people think Microsoft SQL Server 'knows' what they did yesterday. As professional SQL Server consultants we are routinely asked by clients to assist with performance issues - after they have occurred. SQL Server does not keep a permanent history of what was running at a given time. What is does track is on a temporary basis only. And usually not in an easily digestible format that can be used to piece together exactly what was running at a given ti