hi all

DTS : Data Transformation service.using DTS object transfor
the data from one database into anothert database.

ex:sqlserver to orcale or ms-acces.....

DTS Used for various data transformations.

Not only between databases, its also used to transfers 
data's between office excel,CSV, text files, MDB also.
Extracting data's from databases to Excel, mdb, csv, text 
files.

We can extract the data's using Queries also(if its from 
database).

compared with query, stored procedure is efficient and fast 
execution.Because stored procedure is program once it 
formed then execute as a program.

SQL query will be compiled everytime it is executed.
Stored procedures are compiled only once when they are 
executed for the first time.

stored proceure compiles only once and stores in database 
managemant system so it is optimized for best performance 
while sql query compiles every time and executes using dbms 
driver so its performance decreses

Every query is submited it will be compiled & then 
executed.where as stored procedure is compiled 
when it is submitted for the first time and this compiled 
content is stored in something called procedure cache,
for subsequent calls no compilation,just execution & hence 
better performance than query. 
In Query we can execute only 1 statement. Stored Procedure: 
In Stored Procedure we can execute Batch of Queries

SP is good for security purpose, as it grant privileges to 
the use.........

compared with sql query, stored procedure is efficient and 
timesaving execution.Because stored procedure is program 
once it formed then execute as a program at the same 
time.coz queries are taking the time

The execution plan will be created when compiling the stored
procedure and permanently stored in the database and so it
is much efficient, But in the case of query the execution
plan will be created at runtime.

Advantage in Programming - If you are using Query in your 
program exe, want to change Query, you have to change query 
and compile it again. But if used Stored procedure, no need 
to recompile just modify the sp. Query is slow and SP is 
fast.

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)