Back around 2001 I obtained a demo of a tool which would take a complex SQL query and run it against SQL Server many times and come back with a set of performance results. The results were based on different possible variations of sql that would produce the same results. Often the performance improvements were quite drastic and the sql quite imaginative.
Does anyone know of such a tool today?
I'm only looking for performance analysis not a complete database management, monitoring software solution though.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.