Answer Posted / samrat sen

Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.

How to add code to the existing article (using improve article)?

1090

---

What is the difference between a check constraint and a rule?

1219

---

How to create indexed view?

1026

---

How to delete existing rows in a table?

1136

---

How to drop an existing schema in ms sql server?

1078

---

how to define testing of network layers? : Sql server database administration

954

---

What is collation?

1125

---

What is the default value of an integer data type in sql server 2005?

941

---

How to connect to a sql server using odbc_connect()?

1132

---

What is the process of indexing?

985

---

Why I have to use stored procedures?

1017

---

What is faster join or union?

1180

---

what stored procedure would you use to view lock information? : Sql server administration

954

---

What new data source types were added in ssrs 2014?

160

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

999

---