Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
recontrasalo
Starting Member
12 Posts |
 Posted - 2008-02-26 : 11:00:35
|
| How do you schedule a weekly job to do "update statistics" thru all the databases? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-26 : 11:42:43
|
| You can use a Database Maintenance Plan.You can read about Database Maintenance Plans in SQL Server Books Online for the version is SQL Server you are using.CODO ERGO SUM |
 |
|
|
recontrasalo
Starting Member
12 Posts |
Posted - 2008-02-26 : 13:18:40
|
| if u are using the wizard..then u r not a true dba. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-02-26 : 13:24:41
|
quote:
Originally posted by recontrasalo
if u are using the wizard..then u r not a true dba.
That's completely not true. I'm certainly a true DBA and I just this minute used the maintenance plan wizard to create a new maintenance plan for a database. Why would I do it manually when it will do it for me?There are cases where the a maintenance plan is inappropriate but blanket statements like that are certainly wrong.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-26 : 13:44:00
|
quote:
Originally posted by recontrasalo
if u are using the wizard..then u r not a true dba.
Somehow I manage to maintain 200 SQL Servers without being a true DBA.Edit:I am not saying you should never use custom scripts or stored procedures for maintenance; I use them myself. However, I thought that the OP is likely to be a beginner who would have a better chance to success using a maintenance wizard.CODO ERGO SUM |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 13:45:41
|
| 'if u are using the wizard..then u r not a true dba.'Thats not right.You can see Tara's blog for creating maintenance plan using T-SQL. Why you wanna waste your time if you have GUI on hand? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-26 : 15:00:30
|
| The wizard fulfills the task consistently , probably less chance of making a mistake. Also, you can manage your jobs easierJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
update statistics