What is the best practice (in performance-wise) to Import .CSV file into SQL Server ? In my project there is a requirement on which I will upload a .csv (ex.EmployeeData) file from client side and have to validate all the record with existing before inserting to the Database Table so that i can avoid Duplicate record. I am using Angularjs , Web API2 & SQL server 2014 for the above project.What is the best practice (in performance-wise)