Given an array of size N in which every number is between 1
and N, determine if there are any duplicates in it. You are
allowed to destroy the array if you like.
With DTS packaging I can store tables in Excel and convert
them back to SQL. But once I copied tables to Excel I want
to modify some info. How you do that without editing the
Excel file?
Let?s say you have 100,000 records and you want to delete
95,000 at a time and keep only 5 thousand. But in local
memory you don?t have enough space for 95,000 records. What
do you do in this case? How do you delete without any
problem with time and performance?