Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,291 through 4,305 (of 59,087 total)

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

Understood there, as well. No worries. It's not difficult for me to cobble some example tables. I was just going "for the real stuff" just to be sure.

--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 2, 2021 at 10:57 pm

#3959762
Reply To: Arithmetic overflow error converting expression to data type datetime when selec

There are several issues here and the most important of them all is an absolute show stopper for us and almost everyone that has posted has mentioned it in one...
--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 2, 2021 at 12:13 am

#3959344
Reply To: create index columnstore

abdalah.mehdoini wrote:
hello ,
Who has any idea please how to rebuild a clustered index to a clustered columnstore index
thanks
Documentation is your friend. This is an example specifically covered in the following...
--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 8:53 pm

#3959289
Reply To: SQL Agent Driving Me Nuts

davidcb wrote:
Thanks for your speedy replies contacted sys administrator numerous group policies had been applied.
Server now same as other SQL instances no issues running various batch files & agent jobs...
--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:05 pm

#3959254
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, 8 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, 8 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

Viewing 15 posts - 4,291 through 4,305 (of 59,087 total)