One of the common misunderstandings in relation to the Microsoft SQL server is that a primary key always will be enforced with a clustered index. 12 more words