Functions in the WHERE clause are usually not recommended if it is on the table column. Learn why and the workaround in this video.
Join this channel to get access to the perks:
/ @pinaldavesqlauthority
Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/
0:00 Intro
0:14: Story Time
0:36: Demo: Function in Where clause
1:30 Demo: Index Creation
2:24 Follow-up Story
#SQLServer #PerformanceTuning #SQLAuthority