Function in the WHERE Clause - SQL in Sixty Seconds 201

Опубликовано: 23 Октябрь 2024
на канале: Pinal Dave
3,095
170

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