Primary Key vs. Clustered Index
In today’s blog posting I want to talk about a very important topic in SQL Server that always confuses people when they first work with SQL Server. It is about the difference between the Primary Key constraint and the Clustered Index. What is a Primary Key? Let’s talk first about the Primary Key constraint itself. …