Answer Posted / samba shiva reddy . m

Data Transformation Services (DTS), introduced in SQL Server 7.0 and further improved in SQL Server 2000 drastically changed this situation.

We will create the DTS packages mainly for importing and exporting data into data bases.
Importing Problems :
when we importing excel data to Database if the columns in the table and columns in the excel are not same it will give the problem
columns data type miss match.
If first row as Null in Excel it will take all rows as nulls in that column
Maping of the columns.
If Excel contains some rows as number and some rows as columns it may take all rows as nulls.
If we deleted some rows in the last of excel it will import those rows as nulls.
If we importing Date Time columns we have to make sure those are in the correct format.
Exporting Problems
Connection problem
Data type problems
Tab delimitation problem when we export to text document.

What should be the fill factor for indexes created on tables? : sql server database administration

1120

---

What is the Difference Between Primary and Foreign Key?

985

---

Explain how many normalization forms?

1006

---

What is the purpose of sql profiler in sql server?

996

---

How to recompile stored procedure at run time?

1051

---

List out the differences between the clustered index and non-clustered index in sql server?

988

---

What do you mean by authentication modes in sql server?

1063

---

What are commonly used odbc functions in php?

998

---

What happens if null values are involved in datetime operations?

956

---

Mention the differences between sql server and mysql.

997

---

What is a data source or ds? : sql server analysis services, ssas

982

---

What is sql server english query?

1100

---

What is lock escalation? : sql server database administration

1142

---

What is the command used to check locks in microsoft sql server?

1021

---

Why use update_statistics command in sql server?

1028

---