THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Execution Plans   (RSS)
  • The 3rd edition of the ebook SQL Server Execution Plans

    From Redgate website you can download (for free) the ebook SQL Server Execution Plans written by Grant Fritchey and technically reviewed by Hugo Kornelis. This ebook can not be miss in your digital library! Enjoy! 
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on October 24, 2018
  • Skewed Data - Poor Cardinality Estimates... and Plans Gone Bad

    The session Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad by Kimberly Tripp (@KimberlyLTripp) has been published on channel SQLPASS TV.  Abstract When data distribution is heavily skewed, cardinality estimation (how many rows the query optimizer expects each operator to process) can be wildly incorrect, resulting in ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 14, 2014
  • Automating SQL Execution Plan analysis

    Last year, I made my tool for automating execution plan analysis available on www.qdpma.com The original version could parse execution plans from sys.dm_exec_query_stats or dm_exec_cached_plans and generate a cross-reference of which execution plans employed each index. The DMV sys.dm_db_index_usage_stats shows how often each index is ...
    Posted to Joe Chang (Weblog) by jchang on March 22, 2010
  • Automating Query Exec, Index Usage and Execution Plans, Update 2

    I have made updates to my tool for automating SQL Server query exec stats, index usage, execution plan analysis. So I would like people to give it a try and send feedback. If there is an error, please report the file and line number (the top level is sufficient). download at http://www.qdpma.com/tools/ExecStats.zip (check ...
    Posted to Joe Chang (Weblog) by jchang on July 13, 2009
Privacy Statement