The revolutionary project management tool is here! Plan visually with a single glance and make sure your projects get done.
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')