Tag: foreign key

A Simple Use Case for Indexes on Primary Keys

17:13 Database administation, Database development, Indexes, Perfomance Tuning, SQL Server • 3 Comments

Introduction Recently we encountered an interesting performance problem on one of our SQL Server...
Read More

How to Create a Table with Multiple Foreign Keys and Not Get Confused

08:52 Constraints, Database development, Tables

Understanding Table Relations SQL server adds foreign keys to implement relations between tables in a relational database. A table can have...
Read More

SQL FOREIGN KEY CONSTRAINT: The Ultimate, Easy Guide for Newbies

13:06 Constraints, Database development

Newbie? Then an SQL foreign key may be foreign to you. You may have heard different opinions about SQL foreign keys. If you haven’t, soon...
Read More