Best practice of the database design for OLTP (transactional) databases is to have all data at least in the 3rd normal form. After some hands-on experience developers design tables right in the 3RD NF. But in case of any difficulties, it can be done iteration by iteration via following the rules: 1st Normal Form First […]
Read MorePosts tagged INDEX
Using a DDL trigger to control and automate history of data changes
Summary: DDL trigger does all the magic of automatic support of historical data, all you need is to run the script against your database (once). After that you can turn history on tables on, off, or pause it. It will keep audit of all schema changes in your database and automatically generate DML triggers on […]
Read MoreINCLUDE Clause in Non-clustered Indexes
Summary: improve performance of you queries by including hot data into index If you have a big table, let’s say with 100 columns and million rows, and some of those 100 columns, say 5 of them are being used in queries very often, you may significantly improve performance by building a special non-clustered index with […]
Read More
Recent Comments