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 » DMVs » SQL Server 2008 R2   (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
  • SQL Server 2008 R2 SP1 CTP is now available

    Just as I was about to shut my machine down on a Friday, Microsoft goes and releases something we've been waiting on for a long time: a Community Technology Preview (CTP) for Service Pack 1 is finally available for testing! I want to talk about a couple of things that are included in this update that may be of interest [update: I've added a lot ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 22, 2011
  • New / changed columns in SQL Server 2008 R2 DMVs

    I was expecting more changes, but as Denis Gobo already pointed out, there is not a single new DMV in SQL Server 2008 R2.  There have been some column additions, however, as well as a couple that have increased in size.  You might think that I determined this by loading both Books Online collections into some kind of amazing diff tool, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 11, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement