You still mean writing in embedded SQL or what?

I'll go one further...

"Monitor and tune database resources and activities for SQL Server databases"

Does that include being allowed to beat the hell out of developers that write performance challenged code?...

Sorry... If your interview was for the postition of DBA and you do not know these things, you are simply not qualified to be a DBA.

This smacks of a "paging" problem... is that what you're trying to do?

What is "a" and what is "b"... they are not in the table you described.  I realize there is a bit of a language barrier problem here, but do the...

Export to text file.  Use SQL*Loader to load the text file.  Stop using DTS.

Learn what?

Basic SQL?

ANSI SQL?

T-SQL?

Advanced T-SQL?

Performance tuning?

???

Are you doing this using embedded SQL in your VB code?  If you are, that is likely the problem...

Instead of telling us how you want to do something, it would be much more beneficial to yoru cause if you told us what you wanted to do and why....

...and why are you using a cursor?

It tells you...

USE Northwind

EXEC sp_SpaceUsed Customers

name      rows        reserved           data               index_size         unused             
--------- ----------- ------------------ ------------------ ------------------ ------------------ 
Customers 91          104 KB             24 KB              80 KB              0 KB

Heh... DTS?  I don't ever use it .

There might be a more effective way but I'd need to see what you have in...

Not sure what you mean, Steve

>>Performance differens is insignificant...

Is that good or bad?

Unfortunately, that would include me... can't afford the time... I'm too busy fixing performance problems for other folks