I am about to create a table that will be used continuously for inserting into and deleting from. Rows will be inserted into it, a stored procedure will be called that will maniuplate the Rows and then the rows will be deleted. My question is concerning the creation of a clustered index and the re-use of data pages. If I create a clustered index on an ID field and insert a few hundred rows that take up 3 pages (for example). Then I delete the first 50 of those rows and add another 50. Where will the last 50 rows that I added be stored? Will new pages be used at the end of the clustered index? or will it re-use the data pages that were freed up when I deleted the 50 rows? I am thinking that DBReindex would have an effect on the answer here and whether it was called before I added the final 50 rows.