Thanks. One caveat. Notice the strings had different data types (varchar 9 vs 7)? Welcome to procedure cache bloat. connect microsoft com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID 363290
There are thousands of pairwise combinations, so as many SQL plans, compiled/cached. SqlServer limits the number of plans only when the query AND parameters (datatype, length) remain fixed. Perfmon:Compilations
Scott,
Thanks. One caveat. Notice the strings had different data types (varchar 9 vs 7)? Welcome to procedure cache bloat. connect microsoft com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID 363290
There are thousands of pairwise combinations, so as many SQL plans, compiled/cached. SqlServer limits the number of plans only when the query AND parameters (datatype, length) remain fixed. Perfmon:Compilations
Hi Petar
someoneyoulove 2 years ago