Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Insert INTO CTS.CORE.tblStatusTracking ( Select * from CTS.CORE.tblStatusTracking st join ##tblCon2 cc on st.nStatusTrackingID = cc.nStatusTrackingID)
|Union 2 queries to a cte (temp table perhaps)||9||36|
|SQL 2008 R2 syntax||11||29|
|SSRS 2013 - Overlapping reports||2||22|
|any adverse effect when modifying data type on a busy table.||4||13|