With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of the concatenation of two or more strings – if the input is another type than string a conversion will be done implicit. The CONCAT() function takes between 2 and… Read more

Normally I’m not a big fan of using traceflags, my advice is only to use these when it is absolutely necessary otherwise don’t. Here is a list of the documented traceflags that you can use with SQL Server. That is the documented once, besides that there is a list of… Read more

Finally it is here, the SQL Server 2012 RC0 is ready for download, click this link and you’ll be downloading the good stuff in seconds. While you are downloading, you might want to have a look at some of these links, to read the official Microsoft information on what’s new… Read more

Microsoft has recently released the licensing overview for SQL Server 2012. A few things has changes from SQL Server 2008, and I will just give a brief overview over these changes.

CPU vs core

The first major change in my opinion is the change from CPU socket licensing to… Read more

A few weeks back a client of mine 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… Read more

Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you perform the backup or restore from the gui in management studio, it shows you the progres for every 10%. But what to do if you issuet the backup or restore… Read more