Answer / Abhilash Mishra

A unique key constraint ensures that every record in a table has a different value for a specific column or set of columns. In SQL Server, a UNIQUE constraint can be created using the CONSTRAINT keyword followed by the name of the constraint and the keyword UNIQUE, as shown below:nnCREATE TABLE Employees ( n Id INT PRIMARY KEY,n Name NVARCHAR(50) UNIQUE n);

What is extent? Types of extents?

1 Answers  

---

Repair mdf file

2 Answers  

---

Explain the difference between function and stored procedure?

1 Answers  

---

What is the correct order of the logical query processing phases?

1 Answers  

---

What are the new data types are introduced in sql 2000?

1 Answers  

---

What is Service Broker in sql server 2012?

1 Answers   UGC Corporation,

---

What is de-normalization and when do you do it?

3 Answers  

---

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---

What is the command used to recompile the stored procedure at run time?

1 Answers  

---

What is database mirroring?

1 Answers  

---

What are page splits? : SQL Server Architecture

1 Answers  

---

What is the purpose of data source?

1 Answers  

---