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.
USE [db1] DECLARE @endDate datetime DECLARE @startDate datetime SET @startDate = '2011-09-01 00:00:00.000' SET @endDate = '2011-09-30 23:59:59.997' SELECT convert(CHAR(10), SetupTime,104) as 'DATE / CAT' , COUNT(CASE WHEN ((NetworkCause = 0) OR (PrepaidCause = 0)) THEN 0 END) AS 'TOTAL' , COUNT(CASE WHEN ((NetworkCause = 0) OR (PrepaidCause = 0)) AND (LocationZoneID = 167) THEN 0 END) AS 'CFW' , COUNT(CASE WHEN ((NetworkCause = 0) OR (PrepaidCause = 0)) AND (LocationZoneID = 168) THEN 0 END) AS 'NAT' FROM [CDRData] WHERE (Direction = 1) AND (CallClass = 1) AND (SetupTime BETWEEN @startDate AND @endDate) GROUP BY convert(CHAR(10), SetupTime, 104) ORDER BY convert(DATETIME, convert(CHAR(10), SetupTime, 104), 104)
|How to pass 2 IN parameters to a stored procedure using SQL Server 2008?||6||34|
|Need a SQL Server 2014 plug-in to scan the DB schema||4||42|
|SQL Server - Find Parent/Child relationship tree between numeric range.||7||41|