THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server &quo...
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, ...
July 19, 2011
Brought to you by