Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Primary Key (PK) Rss

Search for any content tagged primary key (pk)

   Items 1 to 9 of 9   

The Clustered Index is not the Primary Key

As the title says, the clustered index doesn't have to the primary key and vice versa.  Read more...
By Steve Jones 2016/05/24 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 157 reads

Adding PK Exceptions to SQLCop Tests

In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.  Read more...
By Steve Jones 2016/05/12 | Source: | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 959 reads

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2016/01/26 | Source: | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 2,813 reads

Deciding on a Primary Key in Oracle

Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.  Read more...
By Additional Articles 2015/08/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 4,090 reads

Questions about Primary and Foreign Keys You Were Too Shy to Ask

It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.  Read more...
By Additional Articles 2014/10/14 | Source: SimpleTalk | Category: primary key (pk)
Rating: (not yet rated)  Rate this |   Briefcase | 9,604 reads

Why Primary Keys can be important on large tables

I inherited a database that was getting large and not performing well. After adding primary keys life got better.  Read more...
By Ben Kubicek 2014/06/30 | Source: | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 12,177 reads

Primary Key Primer for SQL Server

Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules, but if you get them right from the start with a database design, the whole process of database development is simpler, and the result is likely to perform better. We asked Phil for advice, little knowing that the explanation might take a while.  Read more...
By Additional Articles 2013/12/19 | Source: SimpleTalk | Category: primary key (pk)
Rating: (not yet rated)  Rate this |   Briefcase | 4,712 reads

Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.   Read more...
By Wagner Crivelini 2010/10/25 | Source: | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 13,046 reads

Ways to minimize sort operations

In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.  Read more...
By Brian Ellul 2010/09/15 | Source: | Category: sort operator
Rating: |  Discuss |   Briefcase | 10,780 reads
   Items 1 to 9 of 9