Performance Troubles - Function on Date Variable - SQL in Sixty Seconds 192

It is possible to get poor performance if the implementation of function on the date variable is not properly thought through. Here are the videos discussed in the video: Optimize DATE in WHERE Clause https://youtu.be/GGwfJ3Sj6a0 Performance: Between and Other Operators https://youtu.be/AL1AQrta1-Q Join this channel to get access to perks: https://www.youtube.com/channel/UCCH2Al33ow5o5CXno2jeZRQ/join Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/ 0:00 Intro 0:14 Real-world Story 0:28 First Video Link 0:38 Second Video Link 0:56 Demo: Function: Between and Operators 1:50 Demo: Performance Troubles - Function on Date Variable 2:37 Final Note #SQLServer #PerformanceTuning #SQLAuthority