syen.j

Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

Yeah we fixed it, we understood the underlying reason from the beginning, we have found our own solution, no magic bullet here, moving on now. Thanks again to all...

February 10, 2017 at 6:31 am

#1927746
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

Michael L John - Friday, February 10, 2017 4:51 AM
Jeff Moden asked a question. Do you understand why he asked this question?
Multiple...

February 10, 2017 at 5:20 am

#1927725
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

"Your questions certainly do sound like a beginner issue because you are looking for some magic to fix your issue. There is no magic. "
If the answer of jcourt...

February 10, 2017 at 12:44 am

#1927696
RE: How to write a string to a file in SQL.

(already posted)

February 9, 2017 at 1:28 pm

#1927646
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

Perry Whittle - Thursday, February 9, 2017 10:03 AM
rebuild the indexes on the events table and then check the free space in...

February 9, 2017 at 12:46 pm

#1927632
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

Perry Whittle - Thursday, February 9, 2017 7:22 AM
syen.j - Thursday, February 9, 2017 2:45 AM

February 9, 2017 at 7:58 am

#1927532
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

John Mitchell-245523 - Thursday, February 9, 2017 7:05 AM
And the shrink command?
OK, so your database is full up. Since your table results...

February 9, 2017 at 7:15 am

#1927521
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

John Mitchell-245523 - Thursday, February 9, 2017 5:23 AM
syen.j - Thursday, February 9, 2017 5:11 AM

February 9, 2017 at 6:36 am

#1927503
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

John Mitchell-245523 - Thursday, February 9, 2017 5:03 AM
Deleting rows doesn't reduce the size of the mdf file. The only operation that...

February 9, 2017 at 5:11 am

#1927485
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

The database is not even in use at the moment, we disconnected all clients before starting to delete. No inserts are happening.
tblEvents
Reserved 87GB
Data 59GB

February 9, 2017 at 4:55 am

#1927480

Viewing 10 posts - 1 through 10 (of 10 total)