Eric Freeman Answered 8 Months ago through
Quizzes
If the set options affecting the plan cache are the same, there will be one query plan retained; however, if they are different (eg. osql (ODBC driver) defaults QUOTED_IDENTIFIER to OFF), there will be two very similar plan_handle's will be retained....