statistics (data)

External Article

Managing SQL Server Statistics

  • Article

Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but if the statistics don't accurately reflect the current contents of the table you'll get a poorly-performing query. How do you find out if statistics are correct, and what can you do if the automatic update of statistics isn't right for the way a table is used?

2013-04-15

6,631 reads

Blogs

The book that made me love goal-setting

By

Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...

Daily Coping 16 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Server Query Tuning and Optimization by Benjamin Nevarez

By

I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...

Read the latest Blogs

Forums

Analyzing execution plan

By dzonibravo96@gmail.com

Hi, can someone help me to understand the following execution plan?  I'm not sure...

#Error for calculation in a textbox

By jeannier175

I am getting the #error when trying to sum a calculated field in ssrs...

how to create index rebuild job on SQL Pas machine

By Diyas

how to create index rebuild job  and stats jobs on SQL Pas machine can...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers