Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_updatestats questions best practices

Status
Not open for further replies.
SteveMe

SteveMe

MIS
Aug 30, 2002
83
US
If I re-index on Sunday. Would all I need to do is run sp_updatestats Mon-Sat or should I updatestats with 10% of the data?

 
Sort by date Sort by votes
If I reindexed my database, I would immediately run the updatestats afterwards. There's no need to run it every day. I would also run updateusage.

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Tempdb ldf file - how best to clear..
Replies
1
Views
458
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Need to restore to reporting server without log file/best way to create reporting server. 1
Replies
7
Views
308
SQLBill
SQLBill
benedictbutlin
  • Locked
  • Question
new to sql server and have a couple of questions 1
Replies
2
Views
179
benedictbutlin
benedictbutlin
dsmbwoy
  • Locked
  • Question
SQL Server - Best Practice For Disk Drive Sizing
Replies
1
Views
140
djj55
djj55
1DMF
  • Locked
  • Question
SQL Replication, what's required , best advice & practice 1
Replies
12
Views
263
biglebowski
biglebowski

Part and Inventory Search

Sponsor

Back
Top