Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,356 through 11,370 (of 59,095 total)

RE: Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found

Joe Torre - Wednesday, August 29, 2018 11:45 AM
Is this a one off, or will this be regularly scheduled load?
Try specifying just...
--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)

August 29, 2018 at 11:53 am

#2003861
RE: index scan where seek expected

jontris - Wednesday, August 29, 2018 9:04 AM
It is gratifying to have stimulated such a lively debate particularly when three of my...
--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)

August 29, 2018 at 9:23 am

#2003823
RE: index scan where seek expected

ScottPletcher - Wednesday, August 29, 2018 8:23 AM
I didn't say cluster based only on "most common queries". I said if (almost)...
--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)

August 29, 2018 at 8:43 am

#2003816
RE: Delete A post

sirkinghorse - Tuesday, August 28, 2018 11:36 PM
I'm struggling to delete a post here
Why? Did you solve the problem the post 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)

August 29, 2018 at 7:25 am

#2003799
RE: Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found

Sergiy - Tuesday, August 28, 2018 8:44 PM
The file has been built incorrectly.
No parsing tool can fix it.
Must be corrected at 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)

August 29, 2018 at 7:17 am

#2003795
RE: I need some help with Text data type in SQL Server table.

rkordonsky 63916 - Wednesday, August 29, 2018 7:05 AM
Sorry guys. The problem was not in SQL Server. In order to see...
--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)

August 29, 2018 at 7:11 am

#2003792
RE: Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found

kashyap4007 - Tuesday, August 28, 2018 8:37 PM
Jeff,
This is public data which i got from website so I think i can share.
...
--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)

August 29, 2018 at 6:43 am

#2003786
RE: Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found

You've still not attached any data but... I'm not sure that you should. Is there any private or sensitive information in the file? And "guru" is just the level of...
--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)

August 28, 2018 at 8:22 pm

#2003757
RE: Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found

kashyap4007 - Tuesday, August 28, 2018 6:11 PM
Can someone help me with loading the attached csv file database.
The issue here is 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)

August 28, 2018 at 7:28 pm

#2003754
RE: Convert Varchar field

Gotta love people that post a question and then disappear after just a couple of hours. After 5 days, I wouldn't expect much.
--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)

August 28, 2018 at 7:04 pm

#2003753
RE: Code to list dates end of month dates between specific start and end date ranges

alexander.lummer - Tuesday, August 28, 2018 1:43 PM
alexander.lummer - Tuesday, August 28, 2018 1:27 PM
--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)

August 28, 2018 at 3:49 pm

#2003738
RE: Are the posted questions getting worse?

Sean Lange - Tuesday, August 28, 2018 3:25 PM
Right??? I have gone down that path. She is a total technophobe...
--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)

August 28, 2018 at 3:45 pm

#2003737
RE: I need some help with Text data type in SQL Server table.

rkordonsky 63916 - Tuesday, August 28, 2018 12:01 PM
Jeff Moden - Tuesday, August 28, 2018 11:54 AM
--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)

August 28, 2018 at 2:52 pm

#2003729
RE: index scan where seek expected

ScottPletcher - Tuesday, August 28, 2018 1:19 PM
Jeff Moden - Tuesday, August 28, 2018 12:15 PM
--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)

August 28, 2018 at 2:48 pm

#2003728
RE: Does SQL compression process takes additional temporary disk space?, 1.2 TB database to compress

Joe Torre - Monday, August 27, 2018 11:48 AM
Your millage may vary. The best way is to experiment in a development environment...
--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)

August 28, 2018 at 2:40 pm

#2003725

Viewing 15 posts - 11,356 through 11,370 (of 59,095 total)