You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored

Post by answerhappygod »

You have a SQL Server 2012 instance that hosts a single-user database.
The database does not contain user-created stored procedures or user-created functions.
You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?

A. Scan for Startup Procs
B. Enable Contained Databases
C. Optimize for Ad hoc Workloads
D. Allow Triggers to Fire Others
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”