Re: Table size and sp_spaceused

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/08/04 

Date: Sun, 8 Aug 2004 09:35:52 -0400

It's just that reindexing does nothing for blobs in 2000 but I am pretty
confident it will help you in your case. 

-- 
Andrew J. Kelly  SQL MVP
"John McLusky" <jmclusky@community.nospam> wrote in message
news:OnVvoESfEHA.3612@TK2MSFTNGP12.phx.gbl...
> Andrew J. Kelly wrote:
> > I am not sure how they calculate the Reserved space but if you had a
> > lot of page splits or just fragmentation in general you need to
> > reindex to free that up.  Do you have a lot of Image or Text columns?
>
> One Text column on the worst table, but I've noticed this before on tables
> with only Int and Varchar columns.
>
> John.
>
>

Relevant Pages

  • Re: Fill Factor
    ... Well the only way it would go back to 90 is if someone or something is reindexing with a different fill factor. ... Andrew J. Kelly SQL MVP ... > database, i deployed a database to a client and sit the Fill Factor for ...
    (microsoft.public.sqlserver.setup)
  • Re: Slow during Inserts
    ... http://www.support.microsoft.com/?id=q224587 Troubleshooting App ... Disk Monitoring ... Andrew J. Kelly SQL MVP "James Juno" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Performance really poor if calling data from sql clients
    ... What is the compatibility level of the db? ... Andrew J. Kelly SQL MVP ... profiler to see what is happening on the sql server end. ...
    (microsoft.public.sqlserver.clients)
  • Re: Log file wont Shrink in Simple Recovery Mode
    ... What does DBCC OPENTRAN() say? ... > Andrew J. Kelly SQL MVP ... As I stated the recovery model is set to simple so it ...
    (microsoft.public.sqlserver.server)
  • Re: Shrink MSDB Data device??
    ... Check to make sure there are no open transactions in the database that are ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)