<img src="https://track.adform.net/Serving/TrackPoint/?pm=268420" width="1" height="1" alt="">
9. december 2015 Skrevet af: Martin Kolding Pedersen Del med en ven     

Microsoft SQL Server Reporting Services har fået en overhaling. Spørgsmålet er, om vi kunne have forventet mere, eller om SSRS bare er blevet endnu bedre og vildere?

[læs mere]
  
17. februar 2014 Skrevet af: Martin Schmidt Del med en ven     

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]
  
15. januar 2014 Skrevet af: Martin Schmidt Del med en ven     

A few weeks back I was visiting a client who asked me to write a script that could tell him the space used by write only indexes. The usage stats from the indexes is pretty easy to get from ‘sys.dm_db_index_usage_stats’ and if you join the DMV ‘sys.dm_db_partition_stats’ onto that, you can from the column ‘used_page_count’ calculate the number of bytes that the particular indexes is wasting.

[læs mere]
  
10. november 2013 Skrevet af: Martin Schmidt Del med en ven     

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]
  
4. november 2013 Skrevet af: Martin Schmidt Del med en ven     

With the release of SQL Server 2012 SP1 CU2, an enhancement to the BACKUP command has been added. Now the BACKUP command support “TO URL” when you specify a backup device. This gives you the option to use an Azure Storage account as destinations for your backups.

[læs mere]
  
1. november 2013 Skrevet af: Martin Schmidt Del med en ven     

Where did I put my Sales table?

[læs mere]