Chris Hedgate
One Orange Chip
Points: 25041
More actions
August 22, 2005 at 1:02 pm
#584020
Yes, and those entries are read from the SGAM and PFS pages. That part is not really stored in every data page, it is just that DBCC PAGE fetches and shows it to us. So like I said, a truncate does not touch any of the data pages at all.
--Chris Hedgate http://www.hedgate.net/Contributor to the Best of SQL Server Central volumesArticles: http://www.sqlservercentral.com/columnists/chedgate/
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply