Whats the best way to deal with tab delimited txt files where several fields in each record need to be compared to corresponding fields on a sql server db table and that table updated as needed.
How do you reduce the number of db hits for making comparisons to each record?
