3 min listen
The Clustered Index is not the Primary Key
FromVoice of the DBA
ratings:
Length:
2 minutes
Released:
May 24, 2016
Format:
Podcast episode
Description
I was reading through a list of links for Database Weekly and ran across this script from Pinal Dave, looking for tables where the clustered index isn't the PK. It struck me that this is one of those facts I consider to be so simple, yet I constantly see people confusing. If you click the Primary Key icon in the SSMS/VS designers, or you specify a PK like this: "The Clustered Index is not the Primary Key"
Released:
May 24, 2016
Format:
Podcast episode
Titles in the series (87)
Lobbying for Change: The Connect system from Microsoft doesn't work that well, but that doesn't mean we shouldn't continue to press Microsoft for change. Read the rest of "Lobbying for Change" at SQLServerCentral. by Voice of the DBA