Manage Learn to apply best practices and optimize your operations.

A surrogate key architecture to perform powerful SQL Server database operations

A surrogate key architecture enables you to have generic administrative routines that can perform many powerful operations on the database schema or the data itself. This technical advice feature describes a suggested surrogate key architecture and provides several support tools.

framework to support a surrogate key architecture. I have written previous articles in support of surrogate keys, but they were mainly rebuttals to ridiculous comments by others. This technical advice feature goes beyond rhetoric and describes a proposed surrogate key architecture. It also provides several T-SQL tools to support the architecture. The following table of contents will help you navigate. Or, go directly to the follow-up feature for a



A surrogate key architecture for powerful database operations

 Home: Introduction
 Part 1: Why use surrogate keys
 Part 2: A surrogate key architecture
 Part 3: Stored procedure: Constraints and indexes
 Part 4: Stored procedure: Examine children
 Part 5: Stored procedures: Investigate related data

More advice: Framework to support a surrogate key architecture


ABOUT THE AUTHOR:   
Brian Walker
Brian Walker is a senior database architect in an IS department that uses SQL Server 2000 and the .NET Framework. He has more than 25 years of experience in the IT industry with the last several years focused on databases and SQL Server. Walker is a software developer, database developer, database administrator and database consultant. He develops utility software as a hobby, including a large collection of SQL Server utilities.
Copyright 2006 TechTarget
This was last published in January 2006

Dig Deeper on SQL Server Database Modeling and Design

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close