17. februar 2014 Skrevet af: Martin Schmidt Del med en ven     

Data and log files are initialized to overwrite any existing data left on the disk from previously deleted files. Data and log files are first initialized by filling the files with zeros when you perform one of the following operations:

• Create a database
• Add files, log or data, to an existing database
• Increase the size of an existing file (including autogrow operations)
• Restore a database or filegroup

20. december 2013 Skrevet af: Martin Schmidt Del med en ven     

We all know that network handling is very expensive, so when loading a large amount of data changing the network package size can improve the performance dramatically. By increasing the package size means that we will transport fewer but larger packages over the network.