Community

Insert Speed and Select Query Performance, Too

(Brian Moran) I have two tables, Account and AccountTransaction, that have more than 20 million records each. There’s a one-to-many (1:M) relationship between Account and AccountTransaction. Data Transformation Services (DTS) constantly loads new records into the tables by using a text file. My comp

Read More - Register for Free Membership