Answer Posted / vamsi krishna

Create table Testing(testingID int,testingdesc varchar(20))
Note: I am not defining TestingID as primaryKey
create clustered index IX_TestingID on Testing(TestingID)
-- This will allow u to insert duplicate values to the
column that has clustered index created.

Instead run the below command to create unique Clustered
Index
create unique clustered index IX_TestingID on Testing
(TestingID)

-- The above statment will not allow u to add duplicate
records.
For your better conformation insert some records into the
tabel and execute a select statement having the clustered
index column in the where clause and check the execution
plan. You can see Index Seek.

Conclusion : Clustered index can be created on non
primaryKey column

What are the results of running this script?

867

---

What is ems sql management studio? : sql server management studio

1052

---

Can you force a query to use a specific index?

893

---

how many bits ip address consist of? : Sql server database administration

854

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

986

---

Why use triggers?

973

---

What are the indexes in sql server?

1041

---

how to avoid cursors? : Sql server database administration

913

---

What stored by the model? : sql server database administration

913

---

Explain try...catch with sql server?

984

---

How to link tables in sql server?

896

---

What are the elements of dbms?

927

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1896

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

898

---

Do you know the cursor types?

1117

---