SQL server file initialization

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

[læs mere]

Network package size

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.

[læs mere]