Explain about the plan freezing in SQL server 2008
Explain about the plan freezing in SQL server 2008.
Expert
Plan freezing is a new concept which permits the DBAs to persist plan guides. Such guides could be reverted to while the queries either drain the resources after the upgrade or fail. The stability to queries is attained by Plan Freezing. Several monitoring characteristics for checking while the query is succeeded or failed are included along with Plan Freezing.
Define the Isolation Levels.
What are the differences between a primary key and a unique key?
What is Null value function?
Give the advantages of MySQL in comparison to Oracle?
In MySql table how many TRIGGERS are allowed?
What is BLOB?
What is the Window PowerShell snaps SQL server provided?
How can we convert between Unix & MySQL timestamps?
Illustrates the Indexes in Structure Query Language?
What are the unique keys of database programming?
18,76,764
1952226 Asked
3,689
Active Tutors
1436989
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!