Welcome to Aussie SQL Server Bloggers
Sign in
|
Join
|
Help
Transaction blog
This Blog
Email
Calendar
Oct
November 2006
Dec
M
T
W
T
F
S
S
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
9
10
Search
Go
Syndication
RSS 2.0
Atom 1.0
Archives
April 2008 (4)
February 2008 (2)
January 2008 (1)
June 2007 (2)
April 2007 (4)
March 2007 (1)
December 2006 (6)
November 2006 (2)
October 2006 (1)
September 2006 (13)
August 2006 (2)
July 2006 (1)
June 2006 (2)
May 2006 (1)
April 2006 (3)
March 2006 (11)
February 2006 (3)
January 2006 (2)
November 2005 (1)
October 2005 (1)
September 2005 (1)
April 2005 (1)
March 2005 (2)
February 2005 (3)
December 2004 (5)
November 2004 (3)
October 2004 (1)
September 2004 (2)
Navigation
Home
Blogs
Photos
Post Categories
Australian SQL Server User Group (4)
Personal stuff (6)
SQL Server - other (6)
SQL Server - Scripts (9)
SQL Server - Technical (19)
Wednesday, 29 November 2006 - Posts
Wednesday, 29 November 2006 11:56 PM
Why defragment tables & indexes at the same time?
Virtually every DBA I talk to about index maintenance seems to defrag tables & indexes together. Here are a few thoughts about why this isn't a good idea.. (a) If overall database performance improves radically after rebuilding your tables, you've
posted by
Greg_Linwood
|
0 Comments
Filed Under:
SQL Server - Technical