Answer Posted / bhaskar

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

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

980

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1009

---

What is difference between commit and rollback when used in transactions?

970

---

Give an example of why you would want to denormalize a database

983

---

What is data modeling and Reterminal integrity?

1963

---

What is trigger and different types of Triggers?

1154

---

How many cores do I need for sql server 2016?

906

---

How to join two tables in a single query in ms sql server?

1001

---

What are sql servers used for?

1055

---

How to get the number of affected rows?

1009

---

Do you know how to implement service broker?

935

---

last function used in MS Access to convert sql what function will use in sql

2079

---

What is sharding?

116

---

How to override dml statements with triggers?

1197

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1041

---