How do you load large data to the SQL server database?

Answer Posted / uma lakshman

Quickest method to load large data into a table is to
use "BCP"(bulk copy).

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When would you prefer to have a minimum number of indexes?

503


Explain the use of containers in ssis and also their types?

522


What is tablix?

115


Can we call future method from queueable?

590


What are the restrictions that views have to follow? : SQL Server Architecture

527






How to truncate the log in sql server 2012? : sql server database administration

567


Can I save my report as html, excel or word? : sql server management studio

541


Explain can you implement data mining in ssrs?

106


What are different types of schemas?

516


Does the unique constraint create an index?

563


What is parameterized reports in ssrs ?

105


What are the hotfixes and patches in sql server?

541


What is the Main Difference between ACCESS and SQL SERVER?

559


Explain indexing and what are the advantages of it?

522


What is difference between join and natural join?

477