Answer Posted / lakshmi

DTS is a kind of etl tool which extracts data from wide
range of sources like flatfiles,sql server,excel,oracle etc
and manipulating the data according to business logic by
using transformations before being loading into various
destinations.

What is the difference between a check constraint and a rule?

1249

---

Is ssrs support other database except ms sql server?

139

---

What security features are available for stored procedure?

1036

---

What is acid properties?

1097

---

Explain the use of containers in ssis?

965

---

Write an sql query for deleting duplicate rows?

995

---

what's new in sql server 2016?

945

---

How many types of stored procedures are there in sql server?

1015

---

Do you know sql server 2008 backup compression?

964

---

What are the two modes of authentication in sql server?

1069

---

How to achieve Paging of records in SQL SERVER?

1100

---

How to return the date part only from a sql server datetime datatype?

1103

---

What is 'write-ahead log' in sql server 2000 ?

1049

---

What happens if you are trying to access a schema not owned by you?

968

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1083

---