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.
What is the difference between BLOB and TEXT?
Explain about Enhanced database mirroring in SQL server 2008.
What are the primary keys of database programming?
Explain about the Sequences in SQL?
Explain advantages of MyISAM over InnoDB?
Define the term Posting in database.
Illustrates the term Linked Server in the SQL Statement?
Explain about encryption of whole databases without the requirement for application changes in SQL server 2008.
Define the Synonyms in Structure Query Language.
What are the fundamental tools of Notification services?
18,76,764
1952538 Asked
3,689
Active Tutors
1449069
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!