#referential integrity

Simple tips for designing for #dataquality

Is your company struggling with the quality of data across and in your enterprise systems? Most, if not all, data quality issues are caused by human error. Data Capture Issues Approximately 80% of errors are simple data capture errors – users entering the wrong information – with the balance largely arising through poor data integration. Over the last fifteen years, we have delivered multiple…

Foreign Key in SQL

What is foreign key in database?

A foreign key is a column or set of columns that is used to establish a relation between two tables. Sometimes, it is also called a reference key. The table in which foreign key is created is called child table. And the table to which it references is called a parent table. The term for the foreign key in relational database terminology is referential integrity…

9 SQL Server Interview Questions

There is always room to learn more about SQL Server by attempting to answer SQL Server interview questions, even if you aren’t looking for a new job. I have written on the subject of interview questions before, but there is a large number of resources on the internet to help you find new questions. This is a list of questions from Deanna Dicken, written several years ago.

What is Referential…