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

924 reads

Blogs

Azure Synapse Analytics new features

By

Almost lost in all the announcements from Ignite was a bunch of amazing new...

Docker, Git and DBATools

By

For those who don’t know, last week was the PASS Summit. It’s an amazing...

SQLSaturday Orlando Notes – Coffee

By

I like to say that the goal for any event is to meet the...

Read the latest Blogs

Forums

result in same line

By patdev99

Hello,   trying to query the result by success or failure in 2 seperate...

Dropping SP's safely

By sizal0234

Hi, Is the below script good to delete 3 sp's... Please let me know...

SQL 2017 Listener with Read-Scale (Clusterless environment) AG not working

By JP10

Hello, I have a Read-Scale AG set up.  I have it failing over back...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers