to export a table data to csv format in sql-server 2008 I have read this question http://stackoverflow.com/questions/14212641/export-table-from-database-to-csv-file
but my table have 4 million of records, in fact I'm doing that, but I think there should be another way to do that,
my `select * from table` is for 10 min and only showing 500 k record