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,   ...

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 ...