TRUNCATE TABLE with partitions
With SQL Server 2016 we’ll see an enhancement to the TRUNCATE TABLE statement. The TRUNCATE TABLE...
Posts om
sql
SQL server file initialization
Når SQL Server opretter eller udvider data- og logfiler, initialiseres de som udgangspunkt ved at...
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...
Backup On-Premises SQL Server Databases to Azure Storage
SQL Server has supported backing up directly to Azure Blob Storage since SQL Server 2012 SP1 CU2....
