Titlebook: Pro SQL Server 2008 Administration; Ken Simmons,Sylvester Carstarphen Book 2009 Ken Simmons and Sylvester Carstarphen 2009 Microsoft SQL S

設(shè)想

Administering Database Objectsanagement Studio, you will see there are several objects and features available to aid you in administering the database. SQL Server even has its own set of system databases that manage data within SQL Server itself. This chapter will walk you through many of these objects and features and explain the impact each one has on you as a DBA.

安慰

Indexing for Performanceattention to the actions of the application and understand that you may have to be flexible with regard to the index creation tips, recommendations, and guidelines that you have researched. The purpose of this chapter is to enhance your understanding of indexes and help you with the development of your rules for creating indexes.

Myosin

Morose

Restore and Recovery Strategies data, and the users and your management will be very unhappy. In the last chapter, we covered the details of creating effective and efficient backup strategies. This chapter will focus on the skills needed to restore a database when the time arises.

BOOST

database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server... .Introduces new administration features of SQL Server 2008 . .Shows how to manage a SQL Server 2008 database at professional level . .Provides guidance on performance optimization ..978-1-4302-2373-3978-1-4302-2374-0

威脅你