Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Extremely large unused/reserved space for table Expand / Collapse
Author
Message
Posted Tuesday, November 11, 2008 7:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
Adi Cohn (11/11/2008)
ALZDBA (11/11/2008)
I would add sp_updatestatistics to the todo list.

(I always combine dbcc updateusage (0) with count_rows and sp_updatestatistics ! )



Are you talking about sp_updatestats? If so why are you running it? AFAIK it has nothing to do with the inaccuracies in the catalog tables. Can you pleas explain the why it is better to run sp_updatestats?

Adi



Both statements alter their part of statistic information in the db.

If you update one part, you might as well update the other.

If catalog data is out of date or inaccurate , imo it is best to update the whole of it.


btw what version of sql2000 are you on ? (sp + cu/hf)


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #600678
Posted Tuesday, November 11, 2008 1:40 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 14, 2014 6:53 AM
Points: 550, Visits: 1,061
ALZDBA (11/11/2008)
Adi Cohn (11/11/2008)
ALZDBA (11/11/2008)
I would add sp_updatestatistics to the todo list.

(I always combine dbcc updateusage (0) with count_rows and sp_updatestatistics ! )



Are you talking about sp_updatestats? If so why are you running it? AFAIK it has nothing to do with the inaccuracies in the catalog tables. Can you pleas explain the why it is better to run sp_updatestats?

Adi



Both statements alter their part of statistic information in the db.

If you update one part, you might as well update the other.

If catalog data is out of date or inaccurate , imo it is best to update the whole of it.


btw what version of sql2000 are you on ? (sp + cu/hf)


I'm running SQL2000 SP4, 64bit quad core processor.
Post #600908
Posted Tuesday, June 23, 2009 2:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 30, 2013 8:20 PM
Points: 1, Visits: 32
http://support.microsoft.com/default.aspx?scid=kb;EN-US;924947

1. make sure every table has clustered index
2. rebuild index for every table.
3. shrink database
4. done
Post #739980
Posted Tuesday, June 23, 2009 3:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:32 AM
Points: 1,327, Visits: 4,504
This is a known issue with SQL2000 on tables with BLOB columns. This KB article explains:-

http://support.microsoft.com/kb/324432

I wrestled with this problem earlier in the year, and the only solution that didn't involve dropping and recreating tables (which I didn't want to do because of the implications for merge replication) was to use dbcc shrinkfile with the "emptyfile" option:-

--add a new file to the database
ALTER DATABASE x ADD FILE(newfile,.........)
--move data from the the existing file to the new file
DBCC SHRINKFILE('oldfile','EMPTYFILE')
--now move it back
DBCC SHRINKFILE('newfile','EMPTYFILE')
--delete the new file
ALTER DATABASE x REMOVE FILE newfile

This worked, and the system was "usable" while this was running... which it wouldn't have been with the other solutions.




Post #740006
Posted Wednesday, December 1, 2010 5:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 1, 2010 5:07 AM
Points: 1, Visits: 3
I had a similar problem and solved using DBCC CLEANTABLE
Post #1028532
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse