PAGE_VERIFY Database Option should be set to “CHECKSUM” . This will reduce your chances of data corruption significantly and has (almost) no performance impact. That almost means a little CPU overhead but yes you should not jeopardize the intergrity of the data being stored for any cost obviously. Yes / No ? Read ahead if the answer is Yes or read ahead anyway since I have type some more stuff.
PAGE_VERIFY Database Option was introduced in SQL server 2005 with three possible values. All the values other than CHECKSUM are basically for backward compatibility but aren’t a wise choice as data write operations do not get the benefit of highest level of verification
This is the recommendation from Microsoft to all major SQL Server MVPs and greats including yours truly (me.. no harm in dreaming).