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.
I guess the reason is because the Notestbl is very large (over 1.5 Mil rec.).
Select * from view_frmOrientationSchedule where exists (Select 1 from dbo.NotesTbl INNER JOIN dbo.View_EmployeesLastNoteID ON dbo.NotesTbl.ID = dbo.View_EmployeesLastNoteID.LastID Where NotesTbl.EmployeeID = view_frmOrientationSchedule.EmployeeID and Date >= '02/01/15')
|Removing SQL Replication from Microsoft SQL Server 2008 R2||2||14|
|Time Duration able to handle overflow of 24+ hours||5||39|
|SQL FUll Text Not returning any results||2||15|
|My Query is not giving correct result. Please help||5||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!