Optimize for Ad Hoc Workloads shrinks the memory that one-time queries take in the plan cache. This post builds a demo of single-use plans, measures their share of the cache, and shows how to read the result. It also covers the cost of the setting and why parameterized queries are the better fix.
OPENROWSET vs Linked Servers: Querying Another Server Safely
Compare OPENROWSET and linked servers, inspect login mappings, keep filtering remote, and review authentication and encryption before use.
Plan Cache Duplicates From Whitespace and Case Differences
One extra space or a lowercase keyword gives you a second cached plan. See it in the cache, and learn what actually fixes it.
Finding Single-Use Plans Wasting Memory in the Cache
Find single-use plans, compare their cache memory with the total, and inspect parameterization before discussing server-wide cache settings.
Optimize for Ad Hoc Workloads: Shrinking a Bloated Plan Cache
One-off queries can fill your plan cache with plans nobody will reuse. Here is the setting that stores a stub instead, and how to check if you need it.
Matching Two Customer Lists When Names and Emails Are Messy
Clean the text, climb from safe rules to fuzzy ones, and keep one best answer per subscriber. A ladder of joins you can paste into SSMS today.