A Transact-SQL statement designed to load data from a text file into a SQL Server table. This is the fastest way of getting data into SQL Server. The bulk insert effectively runs a BCP Load in the SQL Server address space.
The SQL Server uses two types of cache storage: buffer cache, used for storing recently used database pages, and plan cache, which stores execution plans. For details, see glossary definitions of and .