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 » Best Practices » denali » DMVs   (RSS)
  • SQL Server v.Next (Denali) : Breaking change to sys.dm_exec_sessions

    If you're not OCD about prefixing every single column in a query, this is one that might bite you. Today you might have code that assumes that, because database_id is in sys.dm_exec_requests but not in sys.dm_exec_sessions, you don't need to prefix database_id in the following example:SELECT TOP (1)   s.session_id,   ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 19, 2011
  • Connect Digest : 2011-05-09

    This week we're going to look at some issues involving tempdb... Provide a tempdb per database #176241 : Eliminating TempDb By Adding Temp Filegroup to Each Database#281202 : multiple tempdb For these two requests, I am hoping that the Contained Databases feature (which I've talked about multiple times) will get to this capability in the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 9, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement