VossSQL | SQLServerCentral

VossSQL

Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

Perry Whittle (1/6/2014)
What command did you use to check the frags?
Can you post the before and after outputs?
Hi Perry.
To obtain the fragmentation I made the following query:
SELECT
...

January 7, 2014 at 8:42 am

#1678111
RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

Thanks Perry. I did exactly that. I left the file with 75 gb reserved and it is only using 33 gb now in order to have some space for reindexes...

January 5, 2014 at 10:55 pm

#1677645
RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

Thanks!
Yeah, I was considering execute a reindex after the shrink to fix the fragmentation generated. I'll do it and let's see how it goes with the fragmentation before and after....

January 3, 2014 at 2:19 pm

#1677443

Viewing 3 posts - 1 through 4 (of 4 total)