What is Plan freezing?
Submitted by: AdministratorPlan freezing is a new concept that allows the DBAs to persist plan guides. These guides could be reverted to when the queries either fail or drain the resources after the upgrade. The stability to queries is achieved by Plan Freezing. Several monitoring features for checking when the query is succeeded or failed are included with Plan Freezing.
Submitted by: Administrator
Submitted by: Administrator
Read Online MS SQL Server 2008 Job Interview Questions And Answers
Top MS SQL Server 2008 Questions
☺ | What is Table Value Parameters (TVP)? |
☺ | Explain filtered indexes? |
☺ | What is Intellisense? |
☺ | What is Compound Operators? |
☺ | What is MERGE? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |