Answer Posted / anish nama

Sql server 2005 New features:
1.Datatype varchar(max),XML datatype
2.OUTPUT Clause
3.APPLY OPERATOR
4. PIVOT and UNPIVOT?
A Pivot Table can automatically sort, count, and total the
data stored in one table or spreadsheet and create a second
table displaying the summarized data. The PIVOT operator
turns the values of a specified column into column names,
effectively rotating a table.

5.Tools and utilities
Data types
T-SQL enhancements
Programmability enhancements
XML support
Native XML web services
SQL Management Objects
SQL Server Integration Services
SQL Server Reporting Services
SQL Server Notification Services
SQL Server Service Broker
Replication Management Objects
SQL Server Agent
SQL Server Mobile Edition
The code used in the book is available

In sql server2000 Extended Stored procedures , and it
modified it into CLR Stored procedures

Explain the disadvantages/limitation of the cursor?

951

---

What is difference between view and materialized view?

927

---

Why people hate cursor?

1138

---

How can you tell if a database object is invalid?

1068

---

What is Federation and Federation Member?

92

---

what stored procedure can you use to display the current processes? : Sql server administration

1003

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

956

---

Why is the need for data conversion transformations?

1046

---

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

895

---

what are the critical issues you have resloved in your company

1954

---

What does <> symbol mean?

958

---

How to insert stored procedure result into temporary table?

1010

---

What is the difference between index seek vs. Index scan?

1017

---

What is the command dbcc checkdb used for?

1002

---

Do you know what is a trace frag? Where do we use it?

985

---