Erin Stellato
  • Home
  • About
  • SQL Events
  • Library
  • Resources
    • DBCC
    • Internals
    • Performance
    • Statistics
  • Contact Me

You Are Here:   Home » Resources » Statistics

Statistics

Useful statistics references…

The Basics

sys.stats

sys.indexes

sp_createstats

sp_updatestats

sp_helpstats

DBCC SHOW_STATISTICS

STATS_DATE

sp_helpindex (Kimberly L. Tripp)

Statistical maintenance functionality (autostats) in SQL Server

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

 

Statistics Changes in SQL Server 2012

SQL Server 2012 Partitioned Index Default Sampling Algorithm Changes (Joe Sack)

Behavior Changes to Database Engine Features in SQL Server 2012

 

Statistics and Performance

Using Statistics to Improve Performance (MSDN)

 

Filtered Indexes/Statistics

Filtered Indexes – What You Need to Know (Michelle Ufford)

Filtered indexes and filtered stats might become seriously out-of-date (Kimberly Tripp)

A Case of Using Filtered Indexes

Using Filtered Statistics With Partitioned Tables (SQLCAT)

 

The Kitchen Sink

How are auto created column statistics named (Paul Randal)

Changes to automatic update statistics in SQL Server – traceflag 2371

Statistics on Ascending Columns

  • Follow Me Subscribe via RSS! Follow Me On Twitter!
  • Categories
    • Backups (4)
    • CHECKDB (3)
    • Customers (21)
    • DMVs (1)
    • Indexes (9)
    • Internals (7)
    • Maintenance (2)
    • Mentoring (6)
    • PASS (14)
    • Performance (14)
    • Personal (11)
    • Presenting (11)
    • SQLCruise (3)
    • SQLSaturday (5)
    • SQLSequel (4)
    • Statistics (6)
    • Storage (2)
    • The Community (14)
    • Training (11)
    • TSQL Tuesday (10)
    • Vendors (7)
  • Archives
    • February 2013 (1)
    • December 2012 (1)
    • November 2012 (1)
    • September 2012 (1)
    • July 2012 (5)
    • May 2012 (2)
    • April 2012 (2)
    • March 2012 (4)
    • February 2012 (2)
    • January 2012 (4)
    • November 2011 (4)
    • October 2011 (4)
    • September 2011 (2)
    • August 2011 (13)
    • July 2011 (4)
    • June 2011 (4)
    • May 2011 (6)
    • April 2011 (7)
    • March 2011 (3)
    • February 2011 (3)
    • January 2011 (2)
    • December 2010 (3)
    • November 2010 (3)
    • October 2010 (3)
    • September 2010 (3)
    • August 2010 (2)
    • July 2010 (2)
Go To Top

Copyright Erin Stellato, 2010 - 2013