An alternative for Index with Include: CLUSTERED (UNIQUE) Index

Indexes are good and helpful for reading from the tables and one can add different indexes based on any kind of queries that are going to be issued against the tables and make sure they always hit indexes, not the table. But that strategy has a drawback: it'll slow down inserts into the table because … Continue reading An alternative for Index with Include: CLUSTERED (UNIQUE) Index