Technical Article

UPDATE STATISTICS job

This stored precedure can be used within a scheduled job to UPDATE STATISTICS on a data during off hours.I have commented out a parameter used to limit the size of tables to UPDATE STATISTICS.  Script uses the Northwind database.Have a GREAT day!!

2004-07-14 (first published: )

447 reads

Blogs

Techorama 2022 Slides

By

I had a great time at Techorama. I’ll do a writeup on the event,...

Daily Coping 27 May 2022

By

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

Daily Coping 26 May 2022

By

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

Read the latest Blogs

Forums

The 2022 Preview

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The 2022 Preview

OLE DB provider \"SQLNCLI11\" for linked server

By EasyBoy

We have a DTS package running on one of the production server. This is...

Need to provide access to database without giving access to production

By gray6

Hoping I could find some best practice answers here: We have analysts who need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers