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.
IF ((select prin_amount from #ws_cdc_install where end_balance in(select min(end_balance) from #ws_cdc_install)) = (SELECT sum (abs(end_balance))FROM ( SELECT ROW_NUMBER() OVER (ORDER BY due_date desc) AS rownumber, end_balance from #ws_cdc_install ) AS foo WHERE rownumber <= ((select COUNT(*) from #ws_cdc_install)-1))) Begin
|This query failed in sql 2014||5||31|
|Microsoft Access Write errors seem to be caused by bit fields||4||36|
|Correct an issue with a where clause with calculation||2||30|
|SQL Server 2015 Restore - doing it right||2||14|