Answer / naren

New data type XML, Binary
SSIS,SSRS,SSAS

Answer / sakthi

for error handling in 2005 we use try catch, new functions
like pivot and unpivot, datatype nvarchar(max), varchar
(max), char(max) to handle xml in 2005 we have special
datatype caller XML.

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

What are the purposes of floor and sign functions?

0 Answers  

---

How to create a new schema in a database?

0 Answers  

---

What is the difference between composite index and covering index?

0 Answers  

---

---

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  

---

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

---

What is the new security features added in sql server 2016? : sql server security

0 Answers  

---

What is normalization?

9 Answers  

---

What is the difference between clustered index and primary key?

0 Answers  

---

What is ms sql server reporting services?

0 Answers  

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---