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

Reclaiming deleted but unused LOB space in SQL 2005 Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 6:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 10, 2015 4:41 PM
Points: 21, Visits: 559
If it's a heap then add clustered index and then drop it to reclaim unused space.
Post #1405391
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse