What isolation level is your session using? Run DBCC useroptions to see it, along with dateformat, datefirst, language and other SET options.
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
Snapshot Isolation has been in SQL Server since 2005, yet many shops still skip it. A simple example shows how it can reduce blocking transactions.
What a DBA Actually Does All Day
Understand what a DBA does across incidents, prevention, projects, and automation, with practical checks that connect daily work to business risk.
SQL SERVER – List All the DMV and DMF on Server
“How many DMV and DVF are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Training.
SQL SERVER – Finding Expensive Cached Query Statements with DMVs
Finding the Most Expensive Queries starts with choosing a resource measure. I use cached statistics as an investigation aid.
XML nodes: Turn Repeated Elements Into Rows
XML nodes maps elements to rows. Extract values relative to each node, preserve duplicates, and review documents without matching children.
SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index
What does ALTER INDEX ALL REBUILD do when the clustered index is disabled, compared to rebuilding just that index? A step by step demo shows it.