Home > IT Answers > SQL Server > Effective ways for retrieving millions of records from a table?
SQL Server Ask the Experts
2,585 pts.
 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: November 4, 2009  8:48 PM
UPDATED: November 4, 2009  10:29 PM
RELATED QUESTIONS
Answer Wiki:
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 Wiki Answer Submitted:  November 4, 2009  10:29 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _