Insert data into SQL server with best performance

Question

I have an application which intensively uses DB (SQL Server).

As it must have high performance I would like to know the fastest way to insert record into DB.Fastest from the standpoint of execution time.

What should I use ?

As I know the fastest way is to create stored procedure and to call it from code (ADO.NET). Please let me know is there any better way or may be there are is some other practices to increase performance.

Answer 1

a bulk insert would be the fastest since it is minimally logged, perhaps you can use the SqlBulkCopy class