Answer Posted / maddy

Hi,
The DTS and SSIS are both used in SQL Server
Transformations. Th e DTS was used for transformation
purpose upto SQL Server 2000 and SSIS (Including SSAS and
SSRS) are the advanced to DTS and are included in SQL Server
2005 onwards. The capability of SSIS tool in comparison with
DTS is tremendous. This SSIS tool is in competition with
other ETL Tools in the present.The SSIS has lot added
features as per the current requirements.

What is row_number()?

1045

---

Explain table valued parameters in sql server? Why tvp used?

1065

---

What is a performance monitor?

1019

---

what are isolation levels? : Sql server database administration

1054

---

What is difference between after and before?

1182

---

Explain contrast amongst grouped and non-bunched records?

1087

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1242

---

Mention the differences between having and where clause.

1115

---

what is datawarehouse?

1147

---

How to query multiple tables jointly?

1037

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1035

---

How to use copy and concatenate commands in SQL?

1191

---

What is the difference between upgrade and migration in sql server?

1140

---

What is nolock hint in sql server 2008

1178

---

How to change the system date and time from SQL Plus Terminal ?

1267

---