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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2007-08-03 : 09:32:03
|
| Folks:One of my user database has grown to almost 50 GB and most of the space is used by these 2 user tables. The number of rows has in each table is around 5500, but the reservered is very high. What can be done to reduce the space so that my database growth can be brought down.WorkAssignment - Records: 5492, Reserved (KB): 46586448, Data(KB): 46581264, Indexes(KB): 152, Unused(KB): 5032WorkUnit - Records: 5634, Reserved (KB): 15072016, Data(KB): 15065840, Indexes(KB): 152, Unused(KB): 6024Thanks ! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:09:07
|
| Run 'dbcc showcontig' on them to get details. |
 |
|
|
|
|
|
Database Space