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 |
|
Muzaffar557
Starting Member
11 Posts |
 Posted - 2012-01-14 : 06:41:23
|
| Hi There.I used the below query for each tableEXEC sp_spaceused @tableName --In a loop for each tableThe data is as follows:: and on ()name rows reserved data index_size unusedDamageReport 471 184 KB 96 KB 56 KB 32 KBPRJMAT 4144 320 KB 88 KB 8 KB 224 KBgrvdesc 29818 37640 KB 8576 KB 16 KB 29048 KBBatchingPlantLab 5566 1288 KB 816 KB 8 KB 464 KB..Total Unused Space is 4.5GB !!!!!!!Is there any way to free this unused space ??Note:SQL server 2005 Enterprise Edition |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-01-14 : 15:06:26
|
| Unless you're low on disk space, there's no need to reclaim that space (and 4.5 GB is nothing to get excited about). Shrinking to regain space will merely fragment your data and cause performance problems. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-15 : 00:33:19
|
| Where there any deletes done lately ?After Monday and Tuesday even the calendar says W T F .... |
|
|
|
Muzaffar557
Starting Member
11 Posts |
Posted - 2012-01-15 : 02:42:07
|
quote:
Originally posted by robvolk
Unless you're low on disk space, there's no need to reclaim that space (and 4.5 GB is nothing to get excited about). Shrinking to regain space will merely fragment your data and cause performance problems.
Bro i know but management is asking to do it.I need to reduce it any how at any cost .So how do i reclaim unused space |
|
|
|
Muzaffar557
Starting Member
11 Posts |
Posted - 2012-01-15 : 02:44:17
|
quote:
Originally posted by Sachin.Nand
Where there any deletes done lately ?After Monday and Tuesday even the calendar says W T F ....
This database is for entire ERP. So deletion is obvious. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-15 : 04:46:01
|
| What I meant was where there any huge deletes done lately ?After Monday and Tuesday even the calendar says W T F .... |
|
|
|
Muzaffar557
Starting Member
11 Posts |
Posted - 2012-01-15 : 06:04:11
|
quote:
Originally posted by Sachin.Nand
What I meant was where there any huge deletes done lately ?After Monday and Tuesday even the calendar says W T F ....
Huge deletion , yes i usually do it when bulk insert data is wrong.But actually our data is 2 GB the rest 6 GB is crap !Unable to take daily bakup ! |
|
|
|
Sachin.Nand
2937 Posts |
|
|
|
|
|
Unused Space--Eyes popped !!