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

Query Performance Tuning with Filtered Statistics

By

Introduction I recently got a call from our DBA telling me that the CPU...

Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2

By

How to read execution plan to improve poorly... [[ This is a content summary only....

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Read the latest Blogs

Forums

Growing and Changing

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Growing and Changing

Azure Stretch Database, Part I: Getting Going

By SQLBlimp

Comments posted to this topic are about the item Azure Stretch Database, Part I:...

Minimalistic SELECT

By Thomas Franz

Comments posted to this topic are about the item Minimalistic SELECT

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers