Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,306 through 4,320 (of 59,098 total)

Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
The CSVs were created from Excel. I just save as CSV. I am guessing they are tabbed (they do appear in a table format)
The tables do contain confidential information...
--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)

December 1, 2021 at 7:02 pm

#3959239
Reply To: Loading x number of CSV files into x number of unique tables of a database

Ok. Understood on the column names and the table creation.
Is the data in the files separated by commas or tabs?
Also, is there any chance of attaching one of the files...
--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)

December 1, 2021 at 5:02 am

#3958940
Reply To: Creating Markdown Formatted Text for Results from T-SQL

That's kind of cool. Thanks for the article.
Do you have a link to some formal documentation for what the syntax and possible functionality is for this "markdown" language and how...
--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)

November 30, 2021 at 2:24 am

#3958508
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
That would have been my preferred method as well. But the project has been going on for a few years and this is what has been followed historically, even...
--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)

November 30, 2021 at 1:40 am

#3958500
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
The filenames are named with the groups there are in - Filename1_Group1.csv, Filename2_Group1.CSV, Filename3_Group1.csv; Filename1_Group2.csv, Filename2_Group2.CSV, Filename3_Group2.csv, and so on
When I create the dataflow task, I add the name...
--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)

November 30, 2021 at 1:38 am

#3958499
Reply To: Don't Learn, Do It

Michael L John wrote:
An experienced developer complained to me that until SQL has a date, and a time, datatype, it will never be a very good database. This person has been writing...
--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)

November 30, 2021 at 1:19 am

#3958494
Reply To: A Funny Substring NULL

I have to admit that I've never done a SUBSTRING on a NULL directly as in the question. I've not seen anyone even try to do such a thing in...
--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)

November 29, 2021 at 9:31 pm

#3958430
Reply To: Don't Learn, Do It

Ok... here's one for you that a whole lot of people don't understand (borrowing a part of a quote from the article)...
"Don't try to learn T-SQL. Try to learn 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)

November 29, 2021 at 8:09 am

#3957722
Reply To: efficient large table cleanup

That's almost exactly what I suggested in the other post. You ARE trying to delete 41% of the table. After doing that (deletes), you're going to have to rebuild all...
--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)

November 29, 2021 at 1:54 am

#3957660
Reply To: Are there are any way to get partc without make join by Verification Hash?
Avoiding a join here is a mistake, IMHO, especially if the hash-code is going to be used for "verification".
Ah... there's that word... "verification". By itself it can mean so many...
- This reply was modified 4 years, 10 months ago by Jeff Moden. Reason: Corrected a mistake. I original posted an incorrect length and also made an assumption that the data was a simple hash... it's way to big for that
- This reply was modified 4 years, 10 months ago by Jeff Moden. Reason: One more correction... at 64 Bytes, these can be valid hashes using SHA2_512 hashing algorithm
--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)
November 29, 2021 at 1:05 am

#3957650
Reply To: efficient large table cleanup

As a bit of a sidebar, one does have to wonder what the word "efficient" in the post title actually means because, IMHO, you selected to go with the least...
--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)

November 28, 2021 at 11:34 pm

#3957638
Reply To: Which version of SQL should I use?

curtisharrington wrote:
Now I am using SQL to manage school data.
What are you currently using?
--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)

November 28, 2021 at 11:29 pm

#3957637
Reply To: It's All About the Gratitude

You're way too humble. Of course, that's also a part of what makes you so good. 😀 Thanks for what you and the other heavy hitters do.
--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)

November 28, 2021 at 5:52 am

#3957535
Reply To: It's All About the Gratitude

One of the things that I'm most thankful for is the community that has grown around SQL Server Central. I don't know where I'd be without this hub of knowledgeable...
--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)

November 27, 2021 at 6:00 am

#3957381
Reply To: Upcoming contributor milestone

Likewise, you and Phil are the only ones on this thread that I've not yet met in person. Brent did a presentation for us several years back and a couple...
--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)

November 27, 2021 at 5:31 am

#3957379

Viewing 15 posts - 4,306 through 4,320 (of 59,098 total)