Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. MCTS SQL Server 2008 Exam 433... > Exam Objectives Frequently Asked Que...

Exam Objectives Frequently Asked Questions

Q:Can I use the new Declarative Management Framework to enforce a naming convention across my mix of SQL 2005 and SQL 2008 servers?
A:No, the DMF can only be used on SQL 2008 servers.
Q:Can I use the new Change Data Capture feature across my mix of SQL 2005 and SQL 2008 servers?
A:No, the Change Data Capture feature can only be used on SQL 2008 servers.
Q:Can you use compression when backing up a SQL Server 2005 database?
A:No, compression is a new feature available in SQL Server 2008.
Q:Will backup compression take longer to complete?
A:The answer to this is complicated. In general, the disk is the bottleneck, so in most cases, backup compression will actually speed up your backups.
Q:We use an application that uses SQL 2005 DMVs. Will it work with SQL 2008?
A:For the most part the DMVs remain intact. However, you should test your application to be certain.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint