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: Wednesday, December 18, 2013 12:21 PM
Points: 18, Visits: 558
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