Home
Topics
Microsoft SQL Server Administration
SQL-Transact SQL (T-SQL)
Chapter Download: Essential SQL Server 2000 maintenance

Chapter Download

Chapter Download: Essential SQL Server 2000 maintenance

The most important and least glamorous tasks a DBA performs are those that involve maintenance. It's the kind of thing that if you do it, nobody notices; but if you don't, everybody knows. This chapter from the book, Essential SQL Server 2000, by Buck Woody discusses two types of maintenance tasks: tasks that keep the database going and tasks that keep the database going fast.

The primary tool described here for database maintenance is the Database Maintenance Wizard. This graphical tool walks you through setting up a scheduled plan that can include integrity checks, optimizations, and backups. The second set of tools are the T-SQL Database Consistency Check (DBCC) commands. They perform maintenance tasks on a database or an index, as well on filegroups.

Click here to download this free book chapter.

Click here for more information on Addison-Wesley Professional, the author, or to buy the book.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary

This was first published in May 2005

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- No more shortcuts: Sound data quality strategy a must for BI success
  
  In the past, companies might have gotten away with not building data quality efforts into business intelligence programs. That's less likely now.
- Member Exclusive Downloads
  
  Member Exclusive Downloads from SearchBusinessAnalytics
- In-memory applications take on big data analytics challenge
  
  In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.
Data Center
- Battery monitoring service prevents outages, extends battery life
  
  The latest backup battery monitoring services can prevent outages and extend battery life. Plus, they take power monitoring off IT's task list.
- Red Hat Open Hybrid Cloud aids private, public cloud management
  
  Hardware, virtualization, public and private cloud are all converging and need to be managed as one environment. Enter Red Hat's Open Hybrid Cloud.
- Mainframe modernization takes on urgency
  
  A Red Hat Summit talk on database and mainframe modernization highlights urgency, need for agility in enterprise development teams.
Data Management
- Events report: Information Builders Summit 2013, graph databases and more
  
  SearchDataManagement editors discuss the Information Builders user conference and two other events; topics include graph databases and 'data artists.'
- From 4GLs to HTML5 desktop apps: Bringing data to the masses
  
  Advocating wider access to data, speakers at the Information Builders Summit 2013 traced a journey from 4GL tools to HTML5 desktop apps and beyond.
- Enterprise data quality efforts in good company with MDM, governance
  
  Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- The future of Dell Toad: Oracle DBAs can use BI, Exadata features
  
  Dell Toad is pushing itself into business intelligence and now has an edition to support Oracle's big Exadata appliance.
- Unlock the potential of the Oracle Exadata architecture
  
  Despite being almost five years old now, many implementations haven't realized all of the Oracle Exadata architecture benefits.
- The state of Dell Toad: Oracle DBAs and how they can still benefit
  
  Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen.
Content Management
- Cloud collaboration software connects at networking company Enterasys
  
  Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.
- Data value chain puts the focus on what matters most to a business
  
  In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.
- Quiz: Implementing digital asset management systems
  
  Take this quiz to test your knowledge of digital asset management (DAM) technologies and processes.
Windows Server
- Office, 32-bit Windows fixes included in Patch Tuesday update
  
  Microsoft offered five bulletins in June's Patch Tuesday updates, with 19-vulnerability critical Internet Explorer patch and Windows Server 2008 fixes.
- Q&A: Anderson talks BYOD management in Windows Server 2012 R2
  
  Microsoft's Brad Anderson talks about changes to expect in Windows Server 2012 R2 features, including some to security and enterprise mobility.
- Q&A: Microsoft's Brad Anderson talks Windows Server 2012 R2
  
  Microsoft's Brad Anderson discusses new features in Windows Server 2012, including a faster update cycle and cross-platform integration.

All Rights Reserved,Copyright 2005 - 2013, TechTarget