Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2011

CONCAT() – SQL Server 2012

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

2 comments, 567 reads

Posted in SQL Server Notes from the Field on 29 November 2011

SQL Server trace flags

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

1 comments, 1,001 reads

Posted in SQL Server Notes from the Field on 22 November 2011

SQL Server ® 2012 Release Candidate (RC0)

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

0 comments, 375 reads

Posted in SQL Server Notes from the Field on 18 November 2011

SQL Server 2012 licensing

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

0 comments, 632 reads

Posted in SQL Server Notes from the Field on 14 November 2011

How much space are you wasting?

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

2 comments, 426 reads

Posted in SQL Server Notes from the Field on 8 November 2011

Backup/restore/checkdb/shrinkfile progress

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

0 comments, 651 reads

Posted in SQL Server Notes from the Field on 1 November 2011