Posted inSQL Server
TORN_PAGE_DETECTION Internals (SQL 2005 onwards)
CHECKSUM is in the majority of cases the more appropriate PAGE_VERIFY option as it provides a much more complete check (slightly higher overhead) when compared to TORN_PAGE_DETECTION. I thought today however I…