29 Apr
2013
29 Apr
'13
9:41 p.m.
Scott Feldstein
My question is, would I want to turn on the checksum for this data? And, if yes, should I use table checksum or page checksum? What are the advantages / disadvantages of this? I tried searching docs and couldn't find a breakdown so if someone could answer this or point me to a doc or discussion that would be great.
When in doubt, always turn on checksums. Page level means you'll know exactly what page got corrupted while if it was table level, you'll just know "Something in the table is corrupt". The finer grained the better. -- Stewart Smith