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 |
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
 Posted - 2001-08-23 : 04:24:51
|
| When you create a new database in Enterprise Manager you have an option to set the initial size of the data file (.MDF) and the log file (.LDF). If you put any kind of reasonable number in here (say 5Gb) then the database creation takes ages. I read in BOL that this is because SQL Server writes zeros to the disk and then deletes them to ensure that the operating system does not have to do this during normal operation.Does this mean that if you do not specify an initial size then later operations will take longer to process?============The Dabbler! |
|
|
|
|
|
Reserving Space For a New Database