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 » denali » DMVs » SQL 2011   (RSS)
  • Connect Digest : 2011-05-02

    This week, after seeing a lot of the DMV enhancements made in SQL Server 2008 R2 SP1, I thought I would take a look at some dynamic management view/function requests. Page split personality Michael Zilberstein blogged on Monday about how Extended Events and the transaction log differ in the way they report page split information, and that it ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 2, 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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 25, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement