Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2011-02-04 : 11:24:59
|
| Maybe this is some stupid question..but just want to know if there is any luck for me...I am using bcp out to extract the data from a view. The query in the view is horrible(takes 3 hours) :(. So is there a way to use MAXDOP option for a specific bcp? The bcp script which i am using is show below...bcp databaseName..tableName out "c:\tableName.txt" -c -T -S SERVERNAMEany help would be really appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2011-02-04 : 13:46:54
|
| YES...a lottt |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2011-02-04 : 14:08:58
|
| no...MAXDOP is not allowed in a view :(.Our system is a data warehouse and i cannot make any changes for MAXDOP at server level. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2011-02-04 : 16:14:50
|
| OK..thanks for your reply though. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-04 : 16:40:54
|
| How about:bcp "select * from databaseName..tableName OPTION (MAXDOP 1)" queryout "c:\tableName.txt" -c -T -S SERVERNAME |
|
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2011-02-04 : 19:30:14
|
| wow..i guess it should work....i will give it a shot. Thanks!! |
|
|
|
|
|
|
Parallellism?