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 workdate, empId, L.LastName + ', ' + L.FirstName AS Name, ManagerUID, convert(varchar(5), dateadd(second, Total_WorkDate_Units, '0:00:00'),108) as HrsMin, CASE WHEN @Clients = -1 then L.Class IN (2, 6) END from Employee_Work_Units_Summary s inner join dbo.EmployeeList L on s.empId = L.EmployeeId where Total_WorkDate_Units > 32400 AND (L.Suspend = 0) and (ManagerUID = ISNULL(NULLIF (@Supervisor, 0), ManagerUID)) AND (@Employee =0 or L.EmployeeId =@Employee) Order by workdate, Name]
|SQL Server 2008 R2 - Updating Table/Fields Documentation||3||68|
|Managing Columnstore Indexes||2||15|
|Sql Query with datetime||3||10|
|Is it possible to replace huge Multiple Spaces with a single space in SQL Server||2||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!