عنوان

Practical maintenance plans in SQL Server :

(Number (ISBN

1484218957

(Number (ISBN

9781484218952

Erroneous ISBN

1484218949 (print)

Erroneous ISBN

9781484218945

Erroneous ISBN

9781484218945 (print)

Number

b431485

Title Proper

Practical maintenance plans in SQL Server :

General Material Designation

[Book]

Other Title Information

automation for the DBA /

First Statement of Responsibility

Bradley Beard

Specific Material Designation and Extent of Item

1 online resource (xx, 272 pages) :

Other Physical Details

illustrations (some color)

Text of Note

Includes index

Text of Note

Introduction -- 1. Backing Up a Database -- 2. Checking Database Integrity -- 3. Executing SQL Server Agent Jobs -- 4. Purging Log History -- 5. Clearing Old Backup Files -- 6. Rebuilding Indexes -- 7. Reorganizing Indexes -- 8. Shrinking Database Files -- 9. Updating Object Statistics -- 10. Executing T-SQL Statements -- 11. Notifying Database Operators -- 12. Tying It All Together

0

Text of Note

This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that?s it, but there is so much more that can and must be done to ensure the integrity of your most important company resource ? the data you are tasked to manage and safeguard. This book walks even the newest of users through creating a powerful, automated maintenance plan. Automate your job using SQL Server Agent to leverage the power of Maintenance Plans to deliver real, proactive solutions to common issues. Schedule common tasks such as backups and index rebuilds to run automatically, and get early-warning notifications of impending problems relating to resource usage and query performance. By the time your boss knows to call you about a problem, you?ll have already called him to describe your solution. The large majority of books never really cover the topic of inheriting a database server with multiple live databases; the common thread is that the databases will be created and maintained by the reader forever and ever. In the real world, that scenario rarely happens. Practical Maintenance Plans in SQL Server covers that scenario and provides you with the knowledge and tools needed to get comfortable writing your own maintenance plans for any SQL Server database, whether created by you or inherited. Shows the different tasks that can be run in a maintenance plan. Explains how and why those tasks can be implemented. Provides a roadmap to creating your own custom maintenance plan. Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

International Standard Book Number

9781484218945

SQL server

Database management

Number

Edition

Class number

Beard, Bradley

Ohio Library and Information Network

Date of Transaction

20160513113648.4

Cataloguing Rules (Descriptive Conventions))

pn

Electronic name

[Book]

Y