Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pphillips001
Starting Member
23 Posts |
 Posted - 2010-04-15 : 03:53:27
|
| I've compared the physical and index sizes (in Kb) of the tables in our database between dates two weeks apart. Even though the number of rows have increased as expected their physical size has reduced??We haven't manually DBShrank anything. Anybody any ideas on this?Cheers.===========================There is no reality - only perspective. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pphillips001
Starting Member
23 Posts |
Posted - 2010-04-15 : 16:58:17
|
| Yep - we run one of those scripts that if it's defragged past a certain threshold then rebuild index else just a reorg.Would this affect the table data physical size? The index size is listed separately.===========================There is no reality - only perspective. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pphillips001
Starting Member
23 Posts |
Posted - 2010-04-16 : 04:39:11
|
| Thanks Tara - that'd explain it - I thought I was losing the plot for a moment back there!===========================There is no reality - only perspective. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Tables Physical Size shrink on their own-why?