en-UShe-IL
You are here:   Blog
Register   |  Login

Blog Archive:

Maximize
* Can be used in order to search for older blogs Entries

Search in blogs


Blog Categories:

Maximize
* Can be used in order to search for blogs Entries by Categories

Blog Tags:

Maximize
* Can be used in order to search for blogs by keywords

TNWikiSummit


Awared MVP 


 


Microsoft® Community Contributor 


Microsoft® Community Contributor


 Read first, before you you use the blog! Maximize

Recent Entries

By ronen ariely on 23/07/2018 08:38

In this sample code I will present a simple solution to the question "how to drop CLUSTERED INDEX from a PRIMARY KEY column. The case study is that the user created a table with PRIMARY KEY but he did not meant the PRIMARY KEY to become a CLUSTERED INDEX, which is what happen if you do not configure a different CLUSTERED INDEX or you explicitly configure the PRIMARY KEY as a NONCLUSTERED INDEX