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.
How is MyISAM table stored?
What are the primary keys of database programming?
Explain about Enhanced database mirroring in SQL server 2008.
Give the advantages of MySQL in comparison to Oracle?
What are the new capabilities of SQL server 2008 for persisting BLOB data?
What is BLOB?
Illustrates commands BREAK and COMPUTE?
What is TEXT?
How can we convert between Unix & MySQL timestamps?
In MySql table how many TRIGGERS are allowed?
18,76,764
1924389 Asked
3,689
Active Tutors
1444086
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!