Fast way to import 2GB csv file into SQL Server 2008
You need to use bcp.exe or SSIS. Read Import and Export Bulk Data by Using the bcp Utility (SQL Server) and The Data Loading Performance Guide. Also, read How to Analyze SQL Server Performance to be able to tell why something is slow.

After you've read those, come back with a more actionable question, including structure of table, csv structure, repeatability of the job, access issues etc.