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.