Notes on SQL

Random articles from a puzzled DBA


BackgroundWhen 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. This is …

Continue reading