SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2014

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


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, 1,325 reads

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

The SQL Elephant in my room


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

0 comments, 5,390 reads

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