|
|
|
|
Browse by Tags
All Tags » DMVs » SQL Server &quo... » best practices (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, ...
|
|
|
|
|