12:36 PM
2 hours later…
2:56 PM
@MichaelGreen I have a collision self-test in most places where I use CHECKSUM. And in those places, it's best to use CHECKSUM because I need to be case-insensitive. However, I know I don't have a collision self-test on this column, and I'm not sure where I used it before. It's not in the data mart itself but in the database that contains all the tests and which is used to self-test the data mart.
I have to present build summary that shows where a rule has changed from historical build to present build, which is a pain when rules have no identifier that is guaranteed to stay the same build to build.
XML blobs are necessary to be able to summarize them into fewer tables, hence the checksums. I see a lot of casting XML to nvarchar(max) and comparing for equality in the near future.
« first day (3756 days earlier) ← previous day next day → last day (1076 days later) »