Answer Posted / suresh kaudi

Primary Key: Not allow null values,when we make primary key
automatically create cluster index,primary key we make
other foreign key.

Unique key: allow one null value,we can't make it foreign
key to other table.here we cane make only non-cluster index

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2730

---

Are resultset updatable?

928

---

Where sql server usernames and passwords are stored in a sql server?

971

---

What do I need to start working with sql studio? : sql server management studio

1093

---

What are the system database in sql server 2008?

1017

---

What is oltp (online transaction processing)?

984

---

List the types of recovery model available in sql server?

916

---

How network traffic be reduced by using the stored procedure?

1090

---

How to create a simple stored procedure in ms sql server?

1016

---

What is model database in sql server?

1034

---

How to create a store procedure with encryption?

986

---

What is the fillfactor concept in indexes?

967

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1086

---

Why use identity in sql server?

1078

---

what are candidate key, alternate key and composite key? : Sql server database administration

897

---