Content area

Abstract

Translate

How can that be if I'm checking the fragmentation using SQL Server's Dynamic Management Views (DMVs)? The problem can affect nonclusiered and clustered indexes, and unless you're actively keeping !rack of when the fragmentation threshold triggers he maintenance routine to rebuild an index, you'll never know that you have the problem.

Details

Subject
Servers
Title
Avoiding Index Maintenance Rebuilds
Author
Anonymous
Publication title
SQL Server Magazine; Loveland
Volume
13
Issue
12
Pages
11
Number of pages
1
Publication year
2011
Publication date
Dec 2011
Section
SQL SERVER: QUESTIONS ANSWERED
Publisher
Informa
Place of publication
Loveland
Country of publication
United States
Publication subject
Computers--Computer Programming, Computers--Data Base Management
ISSN
15222187
Source type
Magazine
Language of publication
English
Document type
Commentary
Document feature
Photographs
ProQuest document ID
910803262
Document URL
https://www.proquest.com/magazines/avoiding-index-maintenance-rebuilds/docview/910803262/se-2?accountid=208611
Copyright
Copyright Penton Business Media, Inc. and Penton Media, Inc. Dec 2011
Last updated
2023-08-23
Database
ProQuest One Academic