Tag Archives: administration

Using DBCC Clonedatabase

Posted on May 10, 2017 by way0utwest

I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw this: On a quiet Friday afternoon, this seemed like a good time to experiment. We (Redgate Software) have a salesdemo … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Balloons and Data

Posted on May 9, 2017 by way0utwest

This editorial was originally published on Aug 8. 2013. It is being re-run as Steve is out of the office. We see a lot of questions at SQLServerCentral repeated over the years as workers new to the platform encounter some … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Balloons and Data

Using Trace Flags

Posted on March 17, 2017 by way0utwest

At SQLServerCentral, we recently published a list of all the trace flags from Konstantin Taranov. It’s a great list, and thanks to Konstantin for compiling it. While I haven’t often used trace flags, there are some that have really helped … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Using Trace Flags

Global v Session Trace Flags

Posted on March 16, 2017 by way0utwest

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here. In the article, I … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Global v Session Trace Flags