<img src="https://track.adform.net/Serving/TrackPoint/?pm=268420" width="1" height="1" alt="">
11. oktober 2018 Skrevet af: Martin Schmidt Del med en ven     

Efter september 2019 stopper Microsoft supporten af SQL Server 2008 og 2008 R2. Hvad betyder det så for dig? Det betyder, at der ikke længere vil være hjælp at hente i forhold support, rettelser og sikkerhed, hvilket kan koste dig dyrt. Hvad gør du så, hvis du har en SQL 2008 R2 server? Læs med, når to af vores specialister giver deres bud på, hvordan du på bedste vis opgraderer din SQL server - og hvorfor du skal opgradere, selvom det virker!

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

We all know that network handling is very expensive, so when loading a large amount of data changing the network package size can improve the performance dramatically. By increasing the package size means that we will transport fewer but larger packages over the network.

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

Do you see tables taking up much more space than expected? And when looking at the table design and doing a little math numbers just don’t add up! I have seen issues so many times, where you have a simple little table with only a few thousand rows taking up GB’s of storage space. The case is more or less always the same, and that is what I’ll demonstrate in this blog post.

[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]
  
26. marts 2013 Skrevet af: Henrik Zacher Molbech Del med en ven     

Every now and then standard queries just aren’t sufficient as data sources and therefore it might be neccesary to add an intermediate step. For instance by using a table variable. But using a table variable will by default not return any records. So what do we do, then?

[læs mere]
  
29. november 2012 Skrevet af: Henrik Zacher Molbech Del med en ven     

Have you ever got the request to use special characters, like ( ) / & %, in the names of your measures or dimension attributes in your multidimensional cube, but only to find that the Name property will not accept this? There is a way to implement this even though it is not done on the Name property but involves Translations.

[læs mere]