In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called...

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun. SQLRally On...

New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most. I...

One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan. This Dynamic Management Function allows us to...