Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
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')
|vb.net, web page, SQL holding the selected data in an accessible variable||7||32|
|creating a permanent table from the results of a select statement in sql server 2016||5||29|
|Upgrading to SQL Server 2015 Express||2||29|
|compare date to getdate()||8||13|