Reclaim disk space after DROP columns

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Nacho
    #1

    Reclaim disk space after DROP columns

    Hello,

    I tried to make what one reply advice to recover the disk space after
    DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
    but nothing changes.

    Any other solution?

    Ignacio

    Tags: None
    • Roy Harvey
      #2
      Re: Reclaim disk space after DROP columns

      Be sure to run DBCC UPDATEUSAGE(0) so the the numbers reported about
      page usage will be accurate.

      Roy Harvey
      Beacon Falls, CT

      On 2 Aug 2006 12:41:55 -0700, "Nacho" <nacho.jorge@gm ail.comwrote:
      >Hello,
      >
      >I tried to make what one reply advice to recover the disk space after
      >DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
      >but nothing changes.
      >
      >Any other solution?
      >
      >Ignacio

        Comment

        • Erland Sommarskog
          #3
          Re: Reclaim disk space after DROP columns

          Nacho (nacho.jorge@gm ail.com) writes:
          I tried to make what one reply advice to recover the disk space after
          DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
          but nothing changes.
          DBCC CLEANTABLE may be what you need to try.


          --
          Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

          Books Online for SQL Server 2005 at
          http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

          Books Online for SQL Server 2000 at
          http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

            Comment

            • Nacho
              #4
              Re: Reclaim disk space after DROP columns

              thanks a lot, it worked perfectly !!!!
              Nacho

              Roy Harvey wrote:
              Be sure to run DBCC UPDATEUSAGE(0) so the the numbers reported about
              page usage will be accurate.
              >
              Roy Harvey
              Beacon Falls, CT
              >
              On 2 Aug 2006 12:41:55 -0700, "Nacho" <nacho.jorge@gm ail.comwrote:
              >
              Hello,

              I tried to make what one reply advice to recover the disk space after
              DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
              but nothing changes.

              Any other solution?

              Ignacio

                Comment

                • Nacho
                  #5
                  Re: Reclaim disk space after DROP columns

                  I have SQL 2005 express, when I send this command you told me(DBCC
                  CLEANTABLE ) the system doesn't recognize even the command
                  "cleantable ".
                  What am I doing wrong?
                  Nacho

                  Erland Sommarskog wrote:
                  Nacho (nacho.jorge@gm ail.com) writes:
                  I tried to make what one reply advice to recover the disk space after
                  DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
                  but nothing changes.
                  >
                  DBCC CLEANTABLE may be what you need to try.
                  >
                  >
                  --
                  Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
                  >
                  Books Online for SQL Server 2005 at
                  http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

                  Books Online for SQL Server 2000 at
                  http://www.microsoft.com/sql/prodinf...ons/books.mspx

                    Comment

                    • Erland Sommarskog
                      #6
                      Re: Reclaim disk space after DROP columns

                      Nacho (nacho.jorge@gm ail.com) writes:
                      I have SQL 2005 express, when I send this command you told me(DBCC
                      CLEANTABLE ) the system doesn't recognize even the command
                      "cleantable ".
                      What am I doing wrong?
                      Exactly which command did you use? This ran for me:

                      DBCC CLEANTABLE(user test, lingondricka)

                      --
                      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

                      Books Online for SQL Server 2005 at
                      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

                      Books Online for SQL Server 2000 at
                      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                        Comment

                        Previous template Next
                        Working...