Viewing 15 posts - 8,131 through 8,145 (of 59,078 total)
Ya know... I can see why some people might select the first answer. The row exceeds the 8k page and "some data is stored elsewhere". "Some rows" certainly qualifies as...
December 11, 2019 at 5:39 am
Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.
Heh... guess I'm more ancient. I've not found much that will actually beat BCP...
December 11, 2019 at 5:21 am
On the subject of the article itself, thanks for taking the time to put something so extensive together.
As you said, though... "The recommendations in this article are not...
December 11, 2019 at 5:10 am
I hate the way this site does NOT handle tables. I have a screen wide enough to display the whole table but it's still formatted super narrow so...
December 11, 2019 at 4:55 am
Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.
Heh... guess I'm more ancient. I've not found much that will actually beat BCP for...
December 11, 2019 at 4:21 am
Please post the DDL, including any triggers, constraints, or indexes, that are currently on the table.
December 10, 2019 at 6:47 pm
Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.
Heh... guess I'm more ancient. I've not found much that will actually beat BCP for performance for...
December 10, 2019 at 5:55 pm
Thanks, I thought so, but wanted to be sure newer people to the platform are aware of this.
+1000 to that!
December 10, 2019 at 5:53 pm
Also, do you have some proof of the COUNT(*) vs the COUNT(1) thing? I'm not talking about someone's rhetorical "proof" either. I'm talking about a demonstrable and repeatable...
December 10, 2019 at 5:46 pm
What on Earth would you actually use this for? If you ever do it to an actual database, you will cause a huge explosion in the MDF files as clustered...
December 10, 2019 at 5:35 pm
your "requirements" do not match what you trying to do on the sql so please do clarify it exactly.
To get the records added today - which is what...
December 10, 2019 at 5:08 pm
Heh... no, Grant... you and I are ancient technology. 😀 BCP is still a nasty fast work horse. While it wasn't designed to handle true CSV exports nor even a...
December 10, 2019 at 3:04 pm
I'm with Jeff on this - lots of what is on that are personal preferences and should be decided by each team/organization
For example I do not allow any uppercase ...
December 10, 2019 at 3:00 pm
On the subject of the article itself, thanks for taking the time to put something so extensive together.
As you said, though... "The recommendations in this article are not the ultimate...
December 10, 2019 at 10:33 am
I hate the way this site does NOT handle tables. I have a screen wide enough to display the whole table but it's still formatted super narrow so someone can...
December 10, 2019 at 10:25 am
Viewing 15 posts - 8,131 through 8,145 (of 59,078 total)