Re: sp_spaceused

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: evan b (evan_at_cheapaschips.com.au_removethis)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 15:25:23 +1030

Manish
I MAY have a similar problem - in another post as yet no reply
I have 4 tables with 20+million rows (3rd party app) anyway these tables are
reporting their space used in the 50+gigabytes but the space they are
claiming is about 70-90 gb is there anyway to force them to shrink to
recover this space
I know if you're running sql2k you can run dbcc cleantable and it fixes this
issue - I run 7.0 so my only option is to rebuild the tables and Im waiting
for 6 new drives for the array to do that.

Regards
evan
"write2manish" <write2manish.1h0tp6@mail.webservertalk.com> wrote in message
news:write2manish.1h0tp6@mail.webservertalk.com...
>
> Hi,
>
> I am trying to solve a little puzzle. My database size is like 30 GB
> and i used sp_spaceused to find out which table in my database is the
> one using the max. size. After looking at all the table sizes using
> sp_spaceused the total came out to be only 2GB??? I am not sure who is
> using the other 28GB... Anyone any suggestions????
>
> Thanks in advance,
> Manish
>
>
>
> --
> write2manish
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message629190.html
>

Relevant Pages

  • Re: Cool boat & travel computer
    ... For the "new" PCXT, the biggest FULL HEIGHT hard drive was the Tulin ... drives and 256K of RAM. ... these nice 9-track drives with bus adapter cards and drivers in Computer ... run the custom database, print perfect Meter Cards so the technicians on ...
    (rec.boats.cruising)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... You'll not be using most of the system databases intensively so you don't need to seperate them, I mean locating them on different physical disks. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... For this question you must understand the reason why we should seperate data and log files. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
    (microsoft.public.sqlserver.setup)
  • Re: File Corruption
    ... No one in the 3 institutions have access to their PC's hard drives. ... The "My Documents" is actually a spot on a network drive called the H ... This is probably the most common cause of corruption. ... There is never any valid excuse not to split a database. ...
    (microsoft.public.access.gettingstarted)
  • Re: File Corruption
    ... No one in the 3 institutions have access to their PC's hard drives. ... This is probably the most common cause of corruption. ... There is never any valid excuse not to split a database. ... single shared copy of a front end on a network, ...
    (microsoft.public.access.gettingstarted)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... However for the Install I don't see that the actual core db components there ... According to the database files, you can create your database files on ... Of course these drives must be physically seperated so that ... We are physically separating log and data files on separate disks. ...
    (microsoft.public.sqlserver.setup)