Timeline for Unable to drop file group because it is not empty
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 12, 2023 at 14:22 | vote | accept | SpaceGhost440 | ||
| Jun 11, 2023 at 7:30 | comment | added | Charlieface | The fact there are no pages allocated doesn't mean the filegroup isn't being used, as you have found. Please show the table definition for that table. | |
| Jun 10, 2023 at 21:14 | answer | added | SpaceGhost440 | timeline score: 0 | |
| Jun 10, 2023 at 20:22 | history | edited | SpaceGhost440 | CC BY-SA 4.0 |
added 57 characters in body
|
| Jun 10, 2023 at 20:06 | history | edited | SpaceGhost440 | CC BY-SA 4.0 |
added 501 characters in body
|
| Jun 10, 2023 at 18:31 | answer | added | Sina Hassanpour | timeline score: 0 | |
| Jun 10, 2023 at 2:05 | comment | added | J.D. | "but then your indexes are fragmented, and rebuilding them builds your space way back up" - Yea, but that goes back to my original point that it's wasteful and pointless to rebuild indexes. There's no reason to do so. | |
| Jun 10, 2023 at 0:52 | comment | added | SpaceGhost440 | I agree, but there are times when you need to recover space from a massive delete. Or you can't get more storage. So, yes you could use the old style shrink file, but then your indexes are fragmented, and rebuilding them builds your space way back up. Making recovering that space a wash. So there are valid times when you have to. But, can we not de-rail my question please? I really would like to know what is keeping me from removing that file group. | |
| Jun 10, 2023 at 0:46 | comment | added | J.D. | I understand, but rebuilding is an unnecessary action is my point, regardless of how you do it. Some people will use your scripts with the purpose of rebuilding. Paul states, in the same article, to avoid doing all of this, especially arbitrarily - so there's nothing to argue: "Bottom line – try to avoid running data-file shrink at all costs!" - Paul. | |
| Jun 10, 2023 at 0:36 | comment | added | SpaceGhost440 | @J.D. rebuilding them is part of the movement process. I don't actually issue a rebuild statement. Of course you could argue whether or not this is a good idea with Paul Randal who I took the idea from. :) | |
| Jun 10, 2023 at 0:31 | comment | added | J.D. | FWIW, it's kind of pointless and wasteful to arbitrarily shrink a database and rebuild indexes. Don't get me wrong, it's cool you're creating a thing, but I'd habit a guess you're battling the wrong problems. | |
| Jun 10, 2023 at 0:12 | history | edited | SpaceGhost440 | CC BY-SA 4.0 |
explained how the FG was created
|
| Jun 9, 2023 at 23:49 | comment | added | SpaceGhost440 | @DanGuzman No, no table partitioning. | |
| Jun 9, 2023 at 22:30 | comment | added | Dan Guzman | Are you using table partitioning? | |
| Jun 9, 2023 at 22:23 | history | asked | SpaceGhost440 | CC BY-SA 4.0 |