As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

To verify this, I registered three servers in SSMS 2008, one SQL Server 2000, one SQL Server 2005 and one SQL Server 2008. I then ran queries through the Multi-Server Query interface with a single ...