Unexpected SQL Server 2008 Performance Tip: Avoid local variables in WHERE clause

(Jim Duffy) Sometimes an application needs to have every last drop of performance it can get, others not so much. We’re in the process of converting some legacy Visual FoxPro data into SQL Server 2008 for an application and ran into a situation that required some performance tweaking.

Read More - Register for Free Membership