Nick Duckstein


Enforcing Referential integrity in Microsoft SQL Server 2000

Referential Ingegrity is a critical part of any well designed RDBMS application, not just a part of Oracle, DB2, or some other platform. SQL Server has tools to make it easy, but a developer has to take the time to ensure that it is setup correctly, and ignorance is no excuse. New author Nick Duckstein brings us a look at basic RI and how you can set this up in your database.

5 (2)

2005-01-17

13,619 reads

Blogs

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Datacenter Downtime and SQL backups

By stevec883

I was wondering what others are doing in regards to a datacenter outage and...

Installing missed items in SQL Server

By itmasterw 60042

Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...

Redesign of old Table

By bobski

Hi, I am working on an old database table which stores emails, including From,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers