SQL Server According to Bob

Two guys who work on SQL Server


SQL Server dbcc clonedatabase – Gotcha

The dbcc clonedatabase is a handy command to clone metadata and information such as query disk store. Then you can use the database for various activities …

Read More

DBCC Trace Flags 2562 and 2549

  Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace flags 2562 and 2549 behavior.  Trace flags 2562 and 2549 are documented in knowledgebase article: https://support.microsoft.com/en-us/kb/2634571 and the blog post https://blogs.msdn.microsoft.com/bobsql/2016/06/03/sql-2016-it-just-runs-faster-dbcc-scales-7x-better/ highlights the SQL 2016 DBCC performance improvements. For SQL Server 2008, 2012 and 2014 the trace flag behavior remains […]

Read More