SQL server 2008 Question:
Do you know Plan freezing in sql server 2008?
Answer:
Plan 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.
| Previous Question | Next Question |
| Can you explain Table Value Parameters (TVP) in sql server 2008? | Do you know Resource governor in sql server 2008? |