Browse by Tags

• Data Integrity

• Denormalizing to enforce business rules: Running Totals

  Calculating running totals is notoriously slow, whether you do it with a cursor or with a triangular join. It is very tempting to denormalize, to store running totals in a column, especially if you select it frequently. However, as usual when you denormalize, Read More... Posted Friday, January 23, 2009 2:57 PM by Alexander Kuznetsov | 12 Comments Filed under: Data Integrity, Database Programming, Denormalization

• Denormalizing to enforce business rules: Part 1.

  You cannot use CHECK constraints to compare columns in different rows or in different tables, unless you wrap such functionality in scalar UDFs invoked form a CHECK constraint. What if you actually need to compare columns in different rows or in different Read More... Posted Wednesday, January 21, 2009 6:49 PM by Alexander Kuznetsov | 19 Comments Filed under: Data Integrity, Database Programming, Denormalization