Tag Archives: SQL Server 2012

Behaviour change for delete … output … into in SQL Server 2014

A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded one of our servers from SQL 2012 to SQL 2014 and a job started failing. (Although I haven’t explicitly tested … Continue reading

Posted in SQL Server, T-SQL | Tagged , , , | 4 Comments

The full text error and why I was happy to see it.

The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to three SQL Server 2012 instances. There were quite a few moving parts that needed to be considered as part of … Continue reading

Posted in Database options, Disaster Recovery, SQL Server | Tagged , , , | 2 Comments