Solved

Purge large records but cannot see free space claimed

Posted on 2011-02-26
1
252 Views
Last Modified: 2012-05-11
Hi,
I purging 100 millions of records in my table, after purging completed, I did not seen my table size reduce instead it grow larger, where is my free space ? I have also run dbcc shrinkdatabase and sp_spaceused upadteusage but still I cannot reclaim the space
0
Comment
Question by:motioneye
1 Comment
 
LVL 11

Accepted Solution

by:
JoeNuvo earned 500 total points
ID: 34990324
try re-organize clustered index on that table.
and then shrink database, or shrink file (in filegroup assigned to that table)
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question