Reading Time: 16 minutesIf you have been working with SQL Server for a while, you might have heard of something called referential integrity. This is basically the idea that references between tables are accurate. In SQL Server, there are plenty of times where we’ll need to reference data from one table in another table. Continue Reading
Constraints
SQL Server Primary Key: How it works and 6 rules you need to know
Reading Time: 12 minutesIf you are new to SQL Server and the process of database design, you’ve probably heard of the need to create a primary key column in your tables. You’ve likely been told that “every table needs a primary key“. But do you understand why we need a primary key constraint Continue Reading
Cannot update an IDENTITY column? Here’s why
Reading Time: 7 minutesThe IDENTITY property is an extremely useful tool we can use in SQL Server to automate the values in a column. It can be especially useful for primary key columns. This property will automatically add a new integer value to a column when a new row is inserted into the Continue Reading
SQL Server Unique Index: Everything you need to know
Reading Time: 8 minutesIf you know a thing or two about Clustered indexes and Nonclustered indexes, you might be looking to “round out” the topic with an understanding of what a Unique index is. Unique indexes are a great way to enforce uniqueness in a column other than the Primary Key column. If Continue Reading