The Parameter_Sniffing option can be disabled using the below ALTER DATABASE statement:
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = OFF;
from the Options tab of the Database Properties window, by changing the Parameter_Sniffing value to OFF as follows:
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = OFF;
from the Options tab of the Database Properties window, by changing the Parameter_Sniffing value to OFF as follows:
No comments:
Post a Comment