Forum Discussion
SQL Server Bulk Delete Query
In order to reclaim space from Audit table records, I deleted the rows from the Table and rebuilded Index. But later I came to know that these tables were not having any indexes. So after deletion, t...
ashish35 , if you mean you have a heap table = no clustered index, then you can rebuild the table as it to defrag the table & get back some space, like
ALTER TABLE yourTableName WITH REBUILD;The table will be completley locked dureing the operation, so better schedule if for off-work hour.