Huge Database

I am currently importing 1.4 million records to our database. It will be exciting to see how SQL server handles this large number of records and how will our application cope with the size.

I have never worked with so much data before, on my previous position, the most records we have on a table would amount to thousand records, thus DB performance might not be an issue.