InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Which Feature In Sql Server 2008 Has Surprised You? You Can Name Just One. |
|
Answer» Plan Freezing is a new feature I never thought of. I FIND it very interesting! It is included in SQL Server 2008 CTP5. SQL Server 2008 ENABLES greater query performance stability and PREDICTABILITY by providing new functionality to lock down query plans. This empowers organizations to promote STABLE query plans across hardware server replacements, server UPGRADES, and production deployments. Plan Freezing is a new feature I never thought of. I find it very interesting! It is included in SQL Server 2008 CTP5. SQL Server 2008 enables greater query performance stability and predictability by providing new functionality to lock down query plans. This empowers organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments. |
|