Why is bcp out much faster than select * even when bcp uses select * internally?

Channel:
Peter Schneider
Subscribers:
4,130
Published on ● Video Link: https://www.youtube.com/watch?v=pJCyYcUpTIc


Duration: 2:20
1 views
0

Why is bcp out much faster than select * even when bcp uses select * internally?
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA |
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/263116/adarsh-kumar)Adarsh Kumar |
(dba.stackexchange.com/users/44434/dan-guzman)Dan Guzman |
A special thanks goes out to the (https://dba.stackexchange.com/questions/318928/why-is-bcp-out-much-faster-than-select-even-when-bcp-uses-select-internally)Stackexchange community |

I wish you all a wonderful day! Stay safe :)

select sql-server-2016 sql-server bcp



Other Videos By Peter Schneider


2022-11-02test returns wrong value (but no errors) depending on the presence of spaces around the operator
2022-11-02What kind of plug is this?
2022-11-02Save a json value as variable
2022-11-02Comparing two arrrays
2022-11-02Drawing a surface of revolution
2022-11-02How to print list with newline python?
2022-11-02Need to send decimal number to smart contract for calculations
2022-11-02Regex to add comma between letters
2022-11-02Remove Duplicates in a list while adding up the other fields
2022-11-02Why are normal C-array indices signed while stl indices are unsigned?
2022-11-02Why is bcp out much faster than select * even when bcp uses select * internally?
2022-11-02Unbound Breakpoints in Blazor WASM Project
2022-11-02Subtract with previous index where index is not a number using awk
2022-11-02Could not HEAD 'https://jcenter.bintray.com/com/facebook/react/react-native/maven-metadata.xml'
2022-11-02Using awk to only include column beginning with specific value?
2022-11-01How to hide product form custom field it it has null value and show if it is notnull
2022-11-01Concatenate all previous row values from a TEXT column in reverse order
2022-11-01Function to validate that an email address meets some requirements
2022-11-01How can I define unique epsilons with bounded range for floating point analysis?
2022-11-01Upgradable contract with new inheritance
2022-11-01Method naming conventions "setX" vs "withX"


Tags:
select
sql-server-2016
sql-server
bcp