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 |
|
Elidas
Starting Member
33 Posts |
 Posted - 2008-06-20 : 03:57:15
|
| Can someone explain me how does work that flags?# “Auto Close Flag”# “Auto Create Statistics Flag”# “Auto Shrink Flag”# “Auto Update Flag”ok ok, I suppose that they shrink, update statistics and stuff automatically, but... when? every second? is it ok to leave all them as true?thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-20 : 08:08:49
|
| Where did you get this flag from? |
 |
|
|
contrari4n
Starting Member
27 Posts |
Posted - 2008-06-20 : 14:51:02
|
| You should leave these at their defaults in most cases.The worst thing you can do on a production database is to enable 'Auto Shrink'. This runs every 30 minutes, and results in additional unnecessary I/O.It can also cause fragmentation, both at the physical level on disk and at the logical level within the database.Richardhttp://www.sql-server-pro.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-20 : 15:08:35
|
| "The worst thing you can do on a production database is to enable 'Auto Shrink'. This runs every 30 minutes, and results in additional unnecessary I/O."How it runs every 30 mins? Can you explain? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-20 : 23:43:15
|
| Auto Create Statistics helps too. |
|
|
|
|
|
|
auto**** flags