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

What is a container anyway?

By

Recently there was a thread on Twitter which established that a lot of IT...

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

What permissions do temp stored procedures use?

By

In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Split values after semi colon to rows

By PSB

Hi, I need to split column values after ; to new rows . However...

Determine if DB name has numerics

By MothInTheMachine

I am writing a script to move through specific databases in our server and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers