Abstract
In the previous chapter, I showed you how to create, configure, modify, and drop a database. In this chapter, I’ll show you how tomaintain your database using the Transact-SQL language, including ways to use the ALTER INDEX command for rebuilding or defragmenting indexes and DBCC commands for helping identify database integrity problems. I’ll also demonstrate a new technique introduced in SQL Server 2008 for rebuilding a heap (a table without a clustered index).
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Joseph Sack
About this chapter
Cite this chapter
(2008). Database Integrity and Optimization. In: SQL Server 2008 Transact-SQL Recipes. Apress. https://doi.org/10.1007/978-1-4302-0625-5_23
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0625-5_23
Publisher Name: Apress
Print ISBN: 978-1-59059-980-8
Online ISBN: 978-1-4302-0625-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books