Primary Key (PK)

Primary Key Primer for SQL Server

  • Article

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.

2013-12-19

5,005 reads

Blogs

3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution

By

This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...

The PowerBI Volleyball Report – Organizing Data To Start

By

One of my goals this year was to build a report that I can...

Daily Coping 2 Aug 2021

By

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

Read the latest Blogs

Forums

Function not returning all data.

By David C Young

I inherited this code. Written by a 3rd party. I have 3 servers, 1...

Need to change RS Execution Acct PWD, automatically w/ T-SQL

By Express12

We use a 3rd party vendor to administer our SQL Server service account PWDS....

NOT IN vs. NOT EXISTS

By Ben

This is a basic question which occurred to me while reading something on the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers