Agree with Michael...

@a.dimiz Again the fundamental is same. See my first comment. Primary Key and Clustered Index are two different thing. When we define primary key on a table It goes through 2 stages. One is constraint creation and then Index creation. So When y...

HYPER TEXT is a known term amongst the Internet User Community. Every single time they visit a website, the most common thing they do is click a link that is a hyper text. The best thing is it is hyper because it can take you from “Anywhere to Anywhere...

HYPER TEXT is a known term amongst the Internet User Community. Every single time they visit a website, the most common thing they do is click a link that is a hyper text. The best thing is it is hyper because it can take you from “Anywhere to Anywhere...

@Madhivanan, You are right,What you mentioned here is the default behavior. Kindly refer the **Conclusion** section, Here It is mentioned that "Having a primary key does not imply that clustered index will exist on the primary key under all situat...

Even I ask the same question during interview. Primary Key and Clustered Index are two different things. Developers get confused because they usually misunderstand the following line "On a table when a Primary Key defined by default SQL Server creat...

Well, In CAST you can't apply Style where as in Convert you can apply style. [SQLCommitted][1] [1]: http://SQLCommitted.com...