SqlServerKudos - Changing primary key index structure | AdaTheDev

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Changing primary key index structure | AdaTheDev

published 806 days, 4 hours, 11 minutes ago posted by

AdaTheDev 813 days, 20 hours, 32 minutes ago

Changing primary key index structure | AdaTheDev

Changing the structure of a primary key constraint index from nonclustered to clustered (or from clustered to nonclustered) is not necessarily as straight forward as it first seems. The process of changing it over, involves the constraint being dropped and then recreated. This could potentially cause a problem if you're making the change on a table whilst there could be activity against it.

category: Management | clicked: 3 | | source: www.adathedev.co.uk | show counter code

tags: Indexes, SQL, SQLServer

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos