I'm trying to gain a fuller understanding of storage fragmentation issues at the table level. The basic concern here is: do frequent deletes and inserts of fresh data from/into a table cause fragmentation? Say for example I have a table which, at times, might contain 1 million rows, but typically contains about 100,000 rows. After I shrink the table data (not the allocated space) by deleting the last 900K rows, and then do an insert, where would the data start being appended? Right at the end of the 100K th row?

Thanks

Johnny D.