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... » DMVs   (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
  Privacy Statement