Huge size of unused space problem

Question

Post reply

Huge size of unused space problem

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

ashkan sirous SSCrazy Points: 2733 More actions · Answer 1

Thanks dudes,

I will search e books for solution.

I understood that i need to study more;)

Have a nice time,

Ashkan

Best Regards,
Ashkan

EdVassie SSC Guru Points: 60476 More actions · Answer 2

The space used figures reported by SQL Server can become inaccurate over time. Many people are not concerned by how accurate they are. If you want these values to be accurate, I recommend running DBCC UPDATEUSAGE either monthly monthly or weekly to ensure you have correct values.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 3

Databases are meant to grow! You need space for the data and indexes, many problems come into play if you don't have sufficient room to grow and do proper maintainence.

ashkan sirous SSCrazy Points: 2733 More actions · Answer 4

Dear EdVassie,

Thanks for reply, I will check it...

I already have sqlserver 2000 but i can check it in sqlserver 2005 , if it works , it will be great.

Thanks a lot

Ashkan

Best Regards,
Ashkan

ashkan sirous SSCrazy Points: 2733 More actions · Answer 5

Dear Twinsoft SME,

Thanks for reply, yes I know it must grow.

The problem is I have a table with 16 MB of Data and 25 GB UNUSED SPACE.

Means each 1 Mega Byte data reserved 1.5 Giga byte space in my HARD Disc 🙂

So maybe if i have 500 MB data it grow to 700 GB SIZE:D

Thanks a lot,

ashkan

Best Regards,
Ashkan