Find Tables that need Statistics Update

Indexes and table Statistics play a big role in an OLTP database for better query performance. Maintaining statistics on a weekly basis is important but a heavily updated database tables need more emphasis on Statistics and frequent updates. Instead of trying to issue “sp_updatestats” for the entire database, you can choose tables which are heavily […]

5 (1)

2004-02-17

941 reads

Blogs

Daily Coping 1 Oct 2020

By

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

PASS Virtual Summit 2020 Conference Sessions

By

Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...

Running Express Edition in a Container–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Internal Query Processor Error: The query processor could not produce a query pl

By YSLGuru

Is there a standard method for troubleshooting the below error? Internal Query Processor Error:...

How to extract string between variable characters?

By C-M-A

Hi All, I've got a nasty column that I need to get the name...

Making 1 row from 2

By SQLHeap

I'm struggling a bit here. It seems easy, but I 'm not getting it....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers