Search: surrogate

More Results

Sort by: Relevance | Date

  • Why use surrogate keys

    Contributor Brian Walker explains the benefits of using a surrogate key database architecture, such as stability, performance, simplicity and consistency. Feature   |   SearchSQLServer.com

  • A surrogate key architecture

    Contributor Brian Walker offers a surrogate key architectur that will allow you to perform many powerful operations on the database schema or the data itself. Feature   |   SearchSQLServer.com

  • What are surrogate key values

    Contributor Brian Walker emphasizes that surrogate key values have no intrinsic meaning in this feature. Feature   |   SearchSQLServer.com

  • Utilities to maintain a surrogate key architecture

    You've discovered why and when to work with a surrogate key architecture, and how to establish its framework. In the third installment of this series, learn how to maintain the database with utility routines and stored procedures. Feature   |   SearchSQLServer.com

  • Overview of proposed surrogate key architecture

    Find out which columns and objects you need for a proposed surrogate key architecture. Feature   |   SearchSQLServer.com

  • Standard routines for each table in a surrogate key architecture

    Use these standard stored procedures, user-defined function and triggers when building Brian Walker's proposed surrogate key architecture. Feature   |   SearchSQLServer.com

  • Columns and objects to support a surrogate key architecture

    Ask a group of database administrators if they prefer surrogate keys over natural data keys to implement relationships between tables, and chances are you'll get some very different opinions. In the second part of this special... Feature   |   SearchSQLServer.com

  • What is a surrogate key?

    What is a surrogate key in a table? Ask the Expert   |   SearchOracle.com

  • Data partitioning and surrogate keys

    In designing a database with Oracle partitioning in mind, would it be advisable to create surrogate keys or is it better to remain with the original modelled primary key and create data partitions on the unique key (which is the... Ask the Expert   |   SearchOracle.com

  • 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... Feature   |   SearchSQLServer.com

Search Again: