Traditionally, SQL Server creates one cached execution plan per query. But not all parameters are equal — a query that runs fast for a small dataset might choke when fed larger inputs. Enter Parameter ...