Forum Replies Created

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

  • RE: BREAK

    I gave the correct answer, but I am confused as well when I read BOL after that 🙂

  • RE: Compact, fully indexed, archive database

    As said in my original post, I did use sort_in_tempdb = on. But that gave me about 20 GB of free space.

  • RE: Compact, fully indexed, archive database

    Thanks guys! Worked like a charm.

    REBUILDing on another FG doesn't work (ALTER INDEX doesn't support FG change). But dropping them and then CREATEing them on the other FG was successfull....

  • RE: Compact, fully indexed, archive database

    Yes, indeed it will be hosted on enterprise, but I'm already using (page) compression.

    I think I might give it a try with the filegroup option and see where that leads...

  • Viewing 7 posts - 1 through 7 (of 7 total)