Hi, 

I am trying to solve a little puzzle. My database size is like 30 GB and i u
sed 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 tota
l came out to be only 2GB??? I am not sure who is using the other 28GB... An
yone any suggestions????

Thanks in advance,
Manish

[ Post a follow-up to this message ]

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
>

[ Post a follow-up to this message ]

Transaction log?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"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
>

[ Post a follow-up to this message ]

Obvious also did you total up the indexsizes?
Ive seen tables with indexes being bigger than the data


"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:%23Pp6mzo3EHA.3616@TK2MSFTNGP11.phx.gbl...
> Transaction log?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "write2manish" <write2manish.1h0tp6@mail.webservertalk.com> wrote in
message
> news:write2manish.1h0tp6@mail.webservertalk.com... 
>
>

[ Post a follow-up to this message ]

How you find out your database size?  Did you add log file usage as part of
your database size?

Assume all numbers is correct, it is still possible that a database could
have 30 GB and only use 2GB of its space is used.  In this case, you can run
DBCC SHRINKDATABASE to reclaim unused space.

You could also use DBCC UPDATEUSAGE to correct space usage information in
each table (if you suspect that some table has wrong space usage information
stored in the system table).

--
Stephen Jiang
Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.



"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
>

[ Post a follow-up to this message ]