October 29, 2012 at 1:10 pm
Would there be any slowness in performance if a query involves dateadd(day,datediff(day,1,GETDATE()),0) in the WHERE clause?
October 29, 2012 at 1:33 pm
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.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 30, 2012 at 7:38 am
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.
That answers my question. Thanks Sean.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply