|
|
|
|
Browse by Tags
All Tags » Best Practices » denali » DMVs » SQL Server "Denali" (RSS)
-
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, ...
|
|
|
|
|