Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
SELECT DISTINCT name AS database_name, session_id, host_name, login_time, login_name, reads, writes FROM sys.dm_exec_sessions LEFT OUTER JOIN sys.dm_tran_locks ON sys.dm_exec_sessions.session_id = sys.dm_tran_locks.request_session_id INNER JOIN sys.databases ON sys.dm_tran_locks.resource_database_id = sys.databases.database_id WHERE resource_type <> 'database' and name = 'msdb'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Following an example - removing duplicate strings||4||70|
|Clone table from one server.database to another server.database||24||60|
|Update one rows based on previous row||5||35|
|Ideas on migrating very large system from SQL 2005 to SQL 2014||3||42|
Join the community of 500,000 technology professionals and ask your questions.