Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How can I reduce the amount of unused space in my tables

Avatar of Ian_Clubb
Ian_Clubb asked on
Microsoft SQL Server
9 Comments1 Solution304 ViewsLast Modified:
Hi
My database for my Sage sytem has grown 20GB in the past 3 months after staying constant for approx 2 years an nothing on the application side has caused a large input of data.
I have run a script I found on a website to show me the amount of unused space in the tables, this is the output for the top 4 tables;

Table        Rows         Reserved                  data             Index                     Unused
nltranem      251644           1565448 KB      206552 KB         13240 KB                1345656 KB
nltranlkm      263136           1537688 KB      223712 KB         40640 KB      1273336 KB
povhstm      149253           1170568 KB      156920 KB    11384 KB      1002264 KB
cotimedm      79823            1160896 KB      139840 KB           9360 KB      1011696 KB

How can I truncate the tables to get this unused space back?
Thanks


ASKER CERTIFIED SOLUTION
Avatar of Nightman
NightmanFlag of Australia imageCTO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers