Post reply

SQL 2014 Simple Parameterization

  • November 13, 2015 at 4:36 am

    #322506

    Hi All

    Does anyone know if some of the rules for simple parameterization have been lifted?

    What I mean is, if you submit a trivial enough query to SQL Server, SQL server will automatically parameterize the query so that subsequent queries use the same plans, as long as the queries are the same, except for the literals - This is the way that I understood it. Now, this only works when the subsequent queries are exactly the same (except for the literals), including the same case and spacing. This is how it always worked prior to SQL 2014.

    I was playing around with 2014 instance and noticed that even when changing case and spacing, the subsequent queries still used the plan.

    Just something I noticed......

  • November 13, 2015 at 8:02 am

    #1839618

    Starting 2014 major change has been made to carnality estimator as mentioned here . Lot of speakers have also talked about this during PASS 2015 conference.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply