On Friday, after Microsoft released the CTP, I talked a little bit about the changes you will see in SQL Server 2008 R2 SP1. Namely: new rowcount-related columns in sys.dm_exec_query_stats; extended functionality of the FORCESEEK query hint; a new FORCESCAN query hint; support for 15,000 partitions (to match new ...

After five tries, I've given up trying to install AdventureWorks on machines where Denali exists - even in cases where 2008 or 2008 R2 instances also exist, and when my goal is to install AdventureWorks on earlier releases.  The installer crashes before I can even select which instance to use. First, I downloaded AdventureWorks2008R2_RTM.exe ...