Home Forums SQL Server 2008 SQL Server Newbies Forced Parameterization RE: Forced Parameterization

  • January 23, 2013 at 11:52 am

    #1580223

    SQLSACT (1/23/2013)

    Grant Fritchey (1/23/2013)

    There's a pretty focused set of requirements for forced parameterization to work. It's a lot more expanded than simple parameterization, but it does not include ALL ad hoc queries. Microsoft has the requirements documented in the Books Online.

    Thanks

    I just wanted to confirm that with Forced Parameterization - We will deal with plan "shells" ?

    Thanks

    Plan shells? Not sure what you mean. If you mean plan stubs, then no, that's not from Forced Parameterization. It's from Optimize for Ad Hoc. It's a different setting entirely.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning