<img src="https://track.adform.net/Serving/TrackPoint/?pm=268420" width="1" height="1" alt="">
af Martin Schmidt | 17. februar 2014

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]

SQL Trace Flags Performance tuning SQL Server

af Martin Schmidt | 10. november 2013

SQL Server trace flags

Normally I’m not a big fan of using trace flags, my advice is only to use these when it is absolutely necessary otherwise don’t. Here is a list of the documented trace flags that you can use with SQL Server. That is the documented once, besides that there is a list of undocumented trace flags – and it is as you might already have guessed one of these I’ll be blogging about today.

[læs mere]

SQL Trace Flags T-SQL SQL Server