WebProfIT Consulting
  • Home
  • Cloud
  • SQL
  • Big Data
  • Contact Us
  • RSS

Categories

  • AWS (1)
  • Big Data (1)
  • Cloud (1)
  • SQL (4)
    • Microsoft SQL Server (3)
  • Tips and Tricks (2)
  • Tutorials (1)

Recent Comments

    • Home
    • Tips and Tricks

    Data Normalization

    2016-09-09 Leave a Comment Written by Pavel Danilov
    Data Normalization

    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 More
    SQL, Tips and Tricks
    analytics, data integrity, data normalization, INDEX, OLTP, performance, primary key

    INCLUDE Clause in Non-clustered Indexes

    2016-09-03 Leave a Comment Written by Pavel Danilov

    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
    Microsoft SQL Server, SQL, Tips and Tricks, Tutorials
    BigTable, HOT, INDEX, non-clustered index, performance, primary key, SQL

    Recent Posts

    • How to shrink size of Linux EBS volume in AWS
    • Data Normalization
    • Renaming Primary Keys to Standard
    • INCLUDE Clause in Non-clustered Indexes
    • Using a DDL trigger to control and automate history of data changes

    Archives

    WebProfIT Consulting, Inc. 2016