Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Join with SQL View taking more time in SQL 2016 RE: Join with SQL View taking more time in SQL 2016

  • January 8, 2018 at 11:31 pm

    #1975021

    nirav.gandhi7 - Wednesday, December 27, 2017 10:50 PM

  • We suspect issue is because of parameter sniffing ,reason behind this is because of different operators or joins being used inexecution of both servers. Any idea how can we resolved.

    • can you share your execution plan of both SQL server 2012 & 2016 ?
    Here we are to help you unless if you dont provide correct information, really sorry we will not be able to help you.
     As Thom A said post the DDL sample