Question : I’ve set up a master slave replication in mysql and to make sure that I know if the […]
What is the best way to divide data for random groups?
Question : I would like to have persisted column which will randomly group data for 32 groups according to one […]
SQL 2016 Changing Page Verify Impact
Question : Recently inherited a new SQL server and after some Blitz (Thanks Brent and team) checks have noticed that […]
Check integrity between servers
Question : I have three Database servers, running PostgreSQL 9.2: master01 (Own data center USA) slave01 (Own data center USA) […]
How to detect which indexes have checksums and which ones don’t?
Question : Is there a query that will show which tables / indexes need to be rebuilt so that they […]
How do data checksums interact with streaming replication?
Question : Data checksums are a new feature introduced in 9.3, and: there is a new GUC parameter “ignore_checksum_failure” which […]
Validation of data with checksum vs Binary_checksum
Question : Based on this post, I was able to solve the performance issue by adding indexes and thought I […]
Will I be notified that BACKUP encountered a CHECKSUM error if I use CONTINUE_AFTER_ERROR?
Question : I am in the process of adding the WITH CHECKSUM flag on our daily SQL backups, as part […]
Impacts of a change to the Page Verify option
Question : There’s no doubt about importance of doing regular integrity checks on production databases. I’m testing the impact of […]
How do pages get updated checksum when switching page verification mode from torn page to checksum?
Question : Have an older but large db (6tb on the san) that still has its page verification option set […]