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
Data and log files are initialized to overwrite any existing data left on the disk from previously...
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
With the release of SQL Server 2012 SP1 CU2, an enhancement to the BACKUP command has been added....
Filegroup confusion
Where did I put my Sales table?