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.
select top 1000000 journal.callid from journal, calllog where journal.heatseq in (select max(heatseq) from journal where journaltype = 'Manager Escalation' group by heatseq) and calllog.callid = journal.callid and calllog.callstatus = 'open' group by journal.callid
|kill process lock Sql server||9||46|
|How can i use WITH CTE for checking exist value?||3||30|
|T-SQL: "HAVING CASE" Clause||1||23|
|why sql server only update some statistics in the database ?||3||19|