Notes on SQL

Random articles from a puzzled DBA


Background When SQL Server extends data or log files it fills the newly-acquired space with zeroes, to overwrite any data that may have been there beforehand. This action takes place when a database is created, restored, files are extended or added. This can take a long time, depending upon the amount of space being initialised. …

Continue reading