Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ajay
Starting Member
34 Posts |
 Posted - 2002-02-12 : 03:26:43
|
| Sir, If we delete some records from any table, do empty rows remains in the table or don't.If they do then how can i optimize table size by removing those empty rows.ThanksajayEdited by - ajay on 02/12/2002 03:28:38 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-12 : 03:38:41
|
| There is nothing like Empty Records. if you are looking to free the space that was taken up by the deleted records. i think it will be done automatically. Incase it doesnt because of various reasons like indexes.you can reclaim it by using DBCC SHRINKDATABASE or DBCC CHECKTABLE . Check BooksOnline for furthur information on them . you can use them at off peak server time.--------------------------------------------------------------"Happiness is not something you experience, it's something you remember."Edited by - Nazim on 02/12/2002 03:41:40 |
 |
|
|
|
|
|
empty records