. some of the fields in the table are of size greater than 8 kb and most times it cause page splits which causes slow performance.

. Normalizing a table without considering the implications such as too many joins while pulling out the data designers need to understand the benefits of denormalization as well.

. choosing non clustered indexes based on good selectivity instead of random fields

. Lack of understanding query plans and index seeks over table scans