PARAMETER_SNIFFING Archives - SQLChamp

SQLAzure SQLServer SQLServer on Azure VM

New Database scoped Configurations

June 7, 2016 Sarabpreet Singh Anand ALTER DATABASE SCOPED CONFIGURATION, azure, Azure SQL Database, CLEAR PROCEDURE_CACHE, compatibility level, DATABASE SCOPED CONFIGURATION, FOR SECONDARY, LEGACY_CARDINALITY_ESTIMATION, MAXDOP, new features, PARAMETER_SNIFFING, QUERY_OPTIMIZER_HOTFIXES, SQL Server 2016

MS introduced new Database scoped configurations in SQL Azure (V12) and SQL Server 2016; Need for new Database Scoped Configurations