Answer / seshagiri

DTS is set of graphical tools and programmable objects,
using that we can extract,transform, and consolidate data
from source in to multiple destinations.

Tasks are....

Transform Data

Copy and Manage Data

Function as Jobs

what is hash nonclustered index

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

List the different normalization forms?

0 Answers  

---

How to list all schemas in a database?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

---

Explain the commands in sql server?

0 Answers  

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

Tell me extended events in sql server 2008?

0 Answers  

---

Do you know how to implement service broker?

0 Answers  

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---