Archives: August 2013
The 9th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 9 contains all the hotfixes released since the initial release of SQL Server 2012 RTM.
Those who are facing severe issues with their environment, they can plan to test CU9 in test environment & then… Read more
In SQL Server versions prior to 2005, it was possible to have invalid data values into a database. That can lead to incorrect result or issue at time of query execution.
SQL Server 2005 brings new option to the DBCC CHECKDB and DBCC CHECKTABLE commands to solve this issue. “DATA_PURITY”,… Read more
sys.dm_tran_locks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms190345.aspx
Returns information about currently active lock manager resources. Each row represents a currently active request to the lock manager for a lock that has been granted or is waiting to be granted.
The columns in the result set are… Read more
sys.dm_tran_session_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188739.aspx
Returns correlation information for associated transactions and sessions.
This DMV helps in correlating the relation between session & transaction. We can get several details about transaction by correcting it will other DMVs & system catalogs.
Query 1 : Query… Read more