Plan freezing - Sql server 2008

Explain Plan freezing in SQL Server 2008.

- Plan freezing is a 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.

- It builds on plan guides and it is intended to lock-down plans for all repeated queries against a database.

- Plan freezing allows an administrator to pick a time when the system is running well.
Table Value Parameters (TVP) - Sql server 2008
A user defined tables are allowed between queries using the Table Value Parameters feature of SQL Server 2008...........
Intellisense in sql server 2008
Prior to SQL Server 2008, IntelliSense was available from third-party products. Red-Gate has a pretty good IntelliSense product..........
PowerShell, included in SQL Server 2008
Windows PowerShell is a new and powerful scripting shell which can be used by developers and administrators for automating server administration.........
Post your comment