Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2014

Two IDs, One database and a Magic Number (and maybe even an empty string)

G’day,

I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least I thought it was odd

Normally, I join with sys.dm_exec_sessions and filter out anything that is a system process (WHERE [sys].[dm_exec_sessions].[is_user_process] = 1 )

However, this time… Read more

0 comments, 284 reads

Posted in measure twice, cut once. on 26 March 2014

The SQL Elephant in my room

G’day,

Are people familiar with the saying “If there’s an elphant in the room, introduce it“? – if not, then to sum up here goes – “An important and obvious topic, which everyone present is aware of, but which isn’t discussed, as such discussion is considered to… Read more

5 comments, 3,443 reads

Posted in measure twice, cut once. on 19 March 2014