>>>Thank you. >>> >>There may be situations when it's not a good choice to let it create clustered index by default and better to make it non-clustered. Say, if your PK is uniqueidentifier and you didn't specify NewSequentialID() as default value. > >I will have to think about this one to understand. Thank you.
Take a look at this blog post to understand better