Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats
SQL Server 2008 R2 SP1 and SQL Server 2012 RTM+ includes actual row count statistics in the sys.dm_exec_query_stats dynamic management view. This includes the total_rows,
SQL Server 2008 R2 SP1 and SQL Server 2012 RTM+ includes actual row count statistics in the sys.dm_exec_query_stats dynamic management view. This includes the total_rows,
SQL Server 2012 introduces the new inaccurate_cardinality_estimate extended event, and I had a few miscellaneous thoughts about it that I wanted to discuss on this
My third guest blog post was published today on SQLPerformance.com: TRANSACTION_MUTEX and Multi-Session Transaction Access This is related to a recent SQL Server instance I
Last Thursday I presented a session at the PASS Winter 2012 Performance Palooza. It was a great experience and I appreciated the opportunity. The topic
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.