Primary Key (PK)

External Article

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

Technical Article

Primary Keys which are not Clustered Indexes in a database

  • Script

Recently I was asked to find all the Primary keys that are not clustered Indexes in the database. I constructed the below script which will help us to locate the primary keys in the database which are not clustered index.

4.2 (5)

You rated this post out of 5. Change rating

2013-09-18 (first published: )

1,915 reads

Blogs

Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore

By

This is more complicated than using the Azure Migration method, but because it’s maxed...

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

A New Word: Redesis

By

redesis – n. a feeling of queasiness while offering someone advice, knowing they might...

Read the latest Blogs

Forums

Extended Event Comfort

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Extended Event Comfort

SQL Database Project in Azure Data Studio

By Daniel Calbimonte

Comments posted to this topic are about the item SQL Database Project in Azure...

AG Rules for Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AG Rules for Databases

Visit the forum

Question of the Day

AG Rules for Databases

Which of these is not a requirement for a database to be added to an Availability Group (AG)?

See possible answers