• Bind queries - as in true ODBC binding?

    Thank you all for your comments so far. Yes, faster execution with a compiled query plan - usually only makes a difference if the procedure gets called frequently, otherwise there is the chance the query plan will get aged out of cache.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/