THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008... » SQL 11   (RSS)
  • 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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 25, 2011
  • Downgrading a database : "You can't get there from here!"

    I see this question a lot: ''I have a SQL Server 2008 R2 database.  Can I attach it to a SQL Server 2008 SP2 instance?'' Part of this stems from the confusion over exactly what 2008 R2 is in the first place.  It is not a service pack to SQL Server 2008; it is its own, full-fledged version.  A lot of people don't fully realize this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 21, 2011
  • Blogging from the PASS Keynote : 2009-11-05

    Bill Graziano took the stage and promised us the shortest keynote yet.  He started by giving thanks to outgoing board members Greg Low, Pat Wright and Kevin Kline.  Wayne Snyder took over and gave an emotional homage to Kevin, who gave 10 solid years to PASS.  Very touching.  Kevin left the stage to a standing ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 5, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement