Home Forums SQL Server 2008 T-SQL (SS2K8) T-SQL Variable vs String Equivalent RE: T-SQL Variable vs String Equivalent
JackIntheBox
SSCrazy
Points: 2022
More actions
April 8, 2013 at 12:06 pm
#1604524
A great article that could be added to this behavior is from Erland SommarsKog. Also as John mentioned, the above query may have been added by developers to avoid Parameter sniffing.
http://www.sommarskog.se/query-plan-mysteries.html