Sean Lange (10/29/2012)

---

sunny.tjk (10/29/2012)

---

Would there be any slowness in performance if a query involves dateadd(day,datediff(day,1,GETDATE()),0) in the WHERE clause?

There of course is some impact to performance but it is actually pretty minimal in this case. The reason the performance impact it minimal is because this is a calculated value, not a value that will change row by row. In other words this will have no impact on index usage/SARGability. I hope that answers your question.