Proper Application Logging
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