Added: 2 years ago
From: DeveloperVideos
Views: 1,474
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:
see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • 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/View­Feedback.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

  • Comment removed

  • Comment removed

Loading...
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more