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

958 reads

Blogs

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

By

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...

Daily Coping 3 Aug 2021

By

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

Read the latest Blogs

Forums

FOR JSON command adding carriage return to output

By fxferguson

I'm pretty new a creating JSON output form SQL server. I'm having trouble with...

Create a delta from downloaded info

By Bruin

I'm looking for some suggestions on how to create a delta file that will...

Last Time Stored Procedure Ran ?

By homebrew01

Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful  as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers