Tag: foreign key

A Simple Use Case for Indexes on Primary Keys

Database administration, Database development, Indexes, Performance 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

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

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