Recently, when I heard SQL Server 2008 had been released I naturally got curious about it, since 2005 was a major improvement over 2000, so I decided to install it. After about 3 hours of hell, over 10 reboots, installing several dependencies (which IMO should have been part of the installation, or at least downloaded and installed automatically during it) and figuring out why the "Performance Counter" check was failing even after manually rebuilding the performance counter several times (turns out the setup was checking the wrong registry key, and not the same one the OS was using - who would have thought...) , I finally managed to get it installed. Now, I have another problem. Executing SQL queries seems to be incredibly slow compared to SQL Server Express 2005, which I still have installed alongside 2008. After running the SQL Profiler on both instances, I notice that the same query, run by the exact same program on the 2 instances result in a different event. On the 2005 instance, it says "RPC:Completed" with the text "exec sp_executesql N' <sql code goes here>", while on the 2008 one it says "SQL:StmtRecompile" and simply contains the SQL code as its text. Basically, when running a very simple SQL ("select * from <table>") on both of the instances, the SQL server 2005 always returns the recordset instantly (00:00:00 on time), while the 2008 instance always takes 2-3 seconds to return the recordset (this is from the same table on both instances, with approximately the same content - 3-4 records less on the 2008 instance actually). Does anyone know what could be causing this? Is there any way to fix it?