Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 59,082 total)

Reply To: Operating System Error on Bulk Insert

David Burrows wrote:
Jeff Moden wrote:
I wrote some T-SQL to read the first row (which contained the column names) and had it create a CREATE TABLE statement from that header and the BCP...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 11, 2023 at 12:35 am

#4148296
Reply To: Split field to top 4

Jonathan AC Roberts wrote:
I think you can beat any splitting function by splitting in code with no need for aggregation.
As there are only a maximum of 4 values you can safely use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 9:41 pm

#4148266
Reply To: Operating System Error on Bulk Insert

That's a good start.
When I was hot and heavy into doing a shedload of them for a whole bunch of different files, I wrote some T-SQL to read the first...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 9:36 pm

#4148265
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
https://ayende.com/blog/198945-B/on-ai-gpt-and-the-future-of-developers
Same problem in that article that many have. The author ends it with a conclusion of "My final conclusion is that this is a really awesome tool to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 9:16 pm

#4148260
Reply To: Operating System Error on Bulk Insert

p.s. And I disagree... getting FORMAT files right isn't really a fright in my book.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 8:07 pm

#4148230
Reply To: Operating System Error on Bulk Insert

Where are the files located? Sounds like a strange question but you have a file path of 'C:\SQLData\WRsales\' for both the data and format files. Understand that file path is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 8:05 pm

#4148229
Reply To: Warning prompt when writing a reply

as_1234 wrote:
When I wrote this reply https://www.sqlservercentral.com/forums/topic/sql-server-database-redunduncy#post-4148195 and pressed submit I got an error "Are you sure you want to do that?"
I could be missing the obvious but I'm not...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 7:56 pm

#4148218
Reply To: Are the posted questions getting worse?

ZZartin wrote:
I could see a huge potential on the sales side, being confidently incorrect is pretty much the only real requirement for a career in marketing 😛
BWAAA-HAAA-HAAA!!!. Now there's a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 7:50 pm

#4148216
Reply To: Is there a way to have SQL Server be aware of a new file?

I don't know of a windows-driven "interrupt" that would do it (and, if someone does, please fire a flare 'cuz I'l love to know it!) but, if if there was...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 5:01 pm

#4148167
Reply To: The Growth of T-SQL

It's difficult to produce such a list of new functionality even when restricted to just those for T-SQL.
One of my OMG! favorite improvements was when the came out with STRING_AGG()...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 4:43 pm

#4148149
Reply To: how to make a col in a table after checking its existence, in one stmt

rajemessage 14195 wrote:
informaton schema was taking 0 cpu and 0 time.
Uh, huh... It did in my example, as well. You should also do more than one test to see why the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 4:32 pm

#4148147
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
As emphatically strong a suggestion as I can make...
If you get the opportunity to take the all-day class on SQL Server 2022 put on by Bob Ward of Microsoft,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 4:26 pm

#4148136
Reply To: Split field to top 4

aitorzur@hotmail.com wrote:
Can we see how "scratch.dbo.DelimitedSplit8K" does the spliting of the string?
Yes. Here's an article that explains how it works and why it's so fast. Don't use the code for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 4:20 pm

#4148135
Reply To: Best way to combine records across databases

pietlinden wrote:
oh god no don't use UNION ALL unless you really need to. Why not just something like this to get all the records you need from each source?
INSERT INTO...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 5:50 am

#4147895
Reply To: Best way to combine records across databases

JuniperJun wrote:
As I said second option is still used but it's slow. @pietlinden
@jeff Moden: which requires a union all? 😅 , No thx
As opposed to what??? The (in your own...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 10, 2023 at 5:43 am

#4147894

Viewing 15 posts - 1,951 through 1,965 (of 59,082 total)