Effective ways for retrieving millions of records from a table?
Home > IT Answers > SQL Server > Effective ways for retrieving millions of rec...
SQL Server Ask the Experts
2445 pts.
0
Q:
Effective ways for retrieving millions of records from a table?
Data Tables, Microsoft SQL Server, SQL tables
I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each.


Software/Hardware used:
SQL Server
ASKED: Nov 4 2009  8:48 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Are you just trying to export the data to a CSV file or something? If so then BCP, DTS, or SSIS will be your best bet.
Last Answered: Nov 4 2009  10:29 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0