17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

Understanding probabilistic theory a.k.a. statistics

In this session you will understand how statistics are used by Query Optimizer to create an optimal execution plan. Learn how to read an histogram and how to optimize the accuracy of the estimation. Understand how to fix some problems like statistical correlations, missing statistics, gap in statistics, wrong estimations. Also you will understand: density, fooling statistics, auto update statistics, filtered statistics and date correlation optimization.
Are the “Estimated number of Rows“ estimating too much? Understand here how it was estimated and give a new meaning to the word “estimated”.
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    fabiano_neves_amorim.jpg

    Fabiano is fascinated by the SQL Server Query Processor and the way it works to optimize queries, procedures and functions. Actually Fabiano works in a Brazilian company called Sr.Nimbus as a SQL Server consulting, he also is a SQL Server MVP, MCP for SQL Server 2000, MCTS and MCITP DBD/DBA/BI. His blog is on http://blogfabiano.com you can fallow him on twitter: @mcflyamorim

    http://blogfabiano.com http://blogfabiano.com/feed/
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.