Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,921 through 4,935 (of 59,071 total)

Reply To: Load folder full of csv files

Thanks for the feedback, Bruin...
Heh... you DO have to pay attention to the resolution of the data. 😀
--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)

July 19, 2021 at 2:29 am

#3911512
Reply To: Load folder full of csv files
Probably not the operating system. Have you checked the files in the two different places for things like...
1. Are the both using the same thing when it comes to Unicode...
--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)
July 17, 2021 at 2:15 pm

#3911213
Reply To: How can I check that SP3 is really installed?

Mr. Brian Gale wrote:
Did you click on the text 'Failed"? That should explain what is wrong.
If I had to guess - you have a 64-bit version of SQL Server installed and are...
--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)

July 16, 2021 at 12:25 am

#3910460
Reply To: How can I check that SP3 is really installed?

eager2learn wrote:
The result of the query SELECT @@VERSION is: "Microsoft SQL Server 2014 - 12.0.2269.0 (X64)"
I don't understand that (X64) because this query is executed in: C:\Program Files (x86)\Microsoft SQL...
--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)

July 16, 2021 at 12:23 am

#3910459
Reply To: Load folder full of csv files

Bruin wrote:
@jeff
Had a strange error processing file from server...
It was the first file that had data...
StartDT: 15 Jul 2021 08:44:42:777 Working on file 25 of 89 files: G:\line_speed\F303-Line10.csv... Msg 2627,...
--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)

July 16, 2021 at 12:14 am

#3910457
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

Dawesi wrote:
Jeff Moden wrote:
On the subject of "sometimes" quoted CSV's...
I totally agree that it shouldn't be necessary. MS has had more that 2 decades to make this "simple" stuff right as...
--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)

July 15, 2021 at 10:15 pm

#3910423
Reply To: How to get total only for today's date for some columns in reslut set
gaurav wrote:
```
 FROM tblRecievedQuantity TRQLEFT JOIN tblOrderQuantity AS TOQ ON TOQ.order_id = TRQ.order_idLEFT JOIN tblIssuedQuantity AS TIQ ON TOQ.order_id = TIQ.order_idLEFT JOIN tblReceivedTrack AS TRT ON TOQ.order_id...
```
--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)
July 15, 2021 at 10:12 pm

#3910422
Reply To: Using an Integer parameter in a WHERE clause

Actually, both OR and ISNULL are horrible for performance and should be avoided... when I say "should be avoided", I'm very close to saying "must be avoided at all costs"...
--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)

July 15, 2021 at 3:12 am

#3908094
Reply To: ETL in 2021 ?

My previous experience with SSIS was to determine a method to make table-to-table transfers like this work much more quickly. The way I did that was I stopped using SSIS...
--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)

July 15, 2021 at 1:51 am

#3908069
Reply To: Comparing every row in one table

Now that you have a couple of answers, I have to ask... why do you need to do this? What will it be used for? What business purpose does it...
--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)

July 15, 2021 at 1:49 am

#3908068
Reply To: How to get total only for today's date for some columns in reslut set

You left out the name of the date column for the two tables you're talking about and you didn't include those names anywhere in the code. With that in mind,...
--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)

July 15, 2021 at 1:10 am

#3908065
Reply To: How can I check that SP3 is really installed?

eager2learn wrote:
A systems works with Windows Server 2012 R2 Standard On this system MS SQL-server 2014 (x86) Express version 12.0.2000.8 is installed. The service pack SP3 had to be installed....
--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)

July 15, 2021 at 12:26 am

#3908057
Reply To: Let SQL profiler and Extended event can't capture the sql statement.

892717952 wrote:
Mr. Brian Gale wrote:
I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.
If I understand your question correctly,...
--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)

July 14, 2021 at 8:46 pm

#3907993
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

On the subject of "sometimes" quoted CSV's...
I totally agree that it shouldn't be necessary. MS has had more that 2 decades to make this "simple" stuff right as have 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)

July 14, 2021 at 8:19 pm

#3907991
Reply To: Create a View with Index
Let's peel one potato at a time. The first stop is the last item in your code...
```
 (jh.ProdQty - jh.QtyCompleted > 0)
```
Do you see any problems with...
--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)
July 14, 2021 at 5:02 am

#3907658

Viewing 15 posts - 4,921 through 4,935 (of 59,071 total)