>Does it remove the row and free up disk space or ???
>
The row is removed always. The space in Sql Server is allocated in pages (8k page size for Windows 2000). If it's the last row on the page than the page will be released otherwise there'll be more room on that page.