Interview Questions

1. What is Caching Mechanisms?

SQL Server avoids compilations of previously executed queries by using these four mechanisms to make plan caching accessible:

  •  Adhoc query caching
  •  Auto parameterization
  •  Prepared queries
  • Stored procedures or other compiled objects
By Hena Parveen 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

6752616 1720 1496 859

Angular

208334 92 71 46

Wordpress

175895 72 64 36