SQL SERVER A Common Design Problem Should the Primary Key Always be a Clustered Index
Posted by: Journey to SQL Authority with Pinal Dave,
on 23 Nov 2009 |
View original | Bookmarked: 0 time(s)
In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature and I use this feature every now and then.The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover, is there any case, where one [...]...