SQL 2008 R2 ryger ud af support
Efter september 2019 stopper Microsoft supporten af SQL Server 2008 og 2008 R2. Hvad betyder det så...
Posts om
sql
TRUNCATE TABLE with partitions
With SQL Server 2016 we’ll see an enhancement to the TRUNCATE TABLE statement. The TRUNCATE TABLE...
Endelig kom opdateringen af MS reporting services - læs dommen her!
Microsoft SQL Server Reporting Services har fået en overhaling. Spørgsmålet er, om vi kunne have...
SQL server file initialization
Når SQL Server opretter eller udvider data- og logfiler, initialiseres de som udgangspunkt ved at...
How much space are you wasting?
A few weeks back I was visiting a client who asked me to write a script that could tell him the...
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....
Filegroup confusion
Where did I put my Sales table?
