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 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