<img src="https://track.adform.net/Serving/TrackPoint/?pm=268420" width="1" height="1" alt="">
af Martin Schmidt | 17. februar 2014

SQL server file initialization

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]

SQL Trace Flags Performance tuning SQL Server

af Martin Schmidt | 15. januar 2014

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 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]

SQL SQL Server

af Martin Schmidt | 20. december 2013

Network package size

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]

Network Performance tuning SQL Server

af Martin Schmidt | 18. november 2013

Are you wasting storage space?

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]

SQL SERVER 2012 Data Management SQL Server

af Martin Schmidt | 10. november 2013

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 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]

SQL Trace Flags T-SQL SQL Server

af Martin Schmidt | 4. november 2013

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. 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]

SQL Azure T-SQL SQL Server Cloud

af Martin Schmidt | 1. november 2013

Filegroup confusion

Where did I put my Sales table?

[læs mere]

SQL Data Management T-SQL SQL Server

af Henrik Zacher Molbech | 26. marts 2013

Using table variables in a SSIS data source is not returning any records

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]

T-SQL SQL Server SSIS Microsoft

af Henrik Zacher Molbech | 29. november 2012

Special characters in SSAS Name properties

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]

SQL SERVER 2012 SQL Server Microsoft

af Henrik Zacher Molbech | 16. november 2012

Throw your server off balance

…Balanced Power Plan that is.

Caring about the nature is most certainly a likeable trait. But did you know that your servers might be doing that without you actively told them to? And it comes with a cost.

[læs mere]

SQL SERVER 2012 SQL Server