Migrate a database from SQL Server 2008 to 2016 and use new features

(Pablo Echeverria) We have a database that requires trace flag 4136 due to performance issues with parameter sniffing, so it had to be put on its own instance to disable the parameter sniffing because most of the queries are created dynamically.

Register to Read