Technical Article

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 […]

(1)

You rated this post out of 5. Change rating

2004-02-17

1,980 reads

Blogs

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

By

I hosted this month, but I decided to put my own entry in as...

Why Databases Still Fascinate Me

By

I get asked a lot about why or how I began working with databases...

Monday Monitor Tips: ServiceNow Integration

By

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Read the latest Blogs

Forums

Member was not found in the cube when the string

By giles.clapham

Hey, I've not done a cube for many years but I find myself supporting...

Implementing PostgreSQL with Python for Real-Time Logging and Monitoring

By sabyda

Comments posted to this topic are about the item Implementing PostgreSQL with Python for...

Identify a Slipstream Installation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identify a Slipstream Installation

Visit the forum

Question of the Day

Identify a Slipstream Installation

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?

See possible answers