THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 2008 R2
Service Pack 1
SQL Server 11
SQL Server 2011
More changes you might not have noticed in SQL Server 2008 R2 SP1 CTP
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 ...
April 25, 2011
SQL Server v.Next (Denali) : Installing AdventureWorks2008R2
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 ...
November 9, 2010
Brought to you by