THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DMVs » Performance   (RSS)
  • A Warning to Those Using sys.dm_exec_query_stats

    The sys.dm_exec_query_stats view is one of my favorite DMVs. It has replaced a large chunk of what I used to use SQL Trace for--pulling metrics about what queries are running and how often--and it makes this kind of data collection painless and automatic. What's not to love? But use cases for the view are a topic for another post. Today I want ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 22, 2010
  • The Hidden Costs of INSERT EXEC

    INSERT and EXEC: relational brothers in arms, helping you get your data and then put it somewhere. But like all brothers, their relationship has its ups and downs and sometimes you need to look just below the surface to see the real issues. In this post I will cover hidden penalties that a decision--seemingly purely aesthetic--can bring to ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 25, 2009
Privacy Statement