Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 59,067 total)

Reply To: Can't Import File

homebrew01 wrote:
Eirikur Eiriksson wrote:
Just a thought, start by importing the file as all character columns, then analyse the data and reconstruct the target table. 😎 I don't like the Import AND...
--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)

March 8, 2022 at 2:31 am

#3995399
Reply To: Can't Import File

water490 wrote:
Jeff Moden wrote:
I think the following error line from those that you provided is the key hint as to what is wrong...
Error 0xc02020c5: Data Flow Task 1: Data conversion failed...
--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)

March 7, 2022 at 9:49 pm

#3995320
Reply To: performance question

Jeffrey Williams wrote:
All it indicates is that this query is called a lot - but if that execution is sub-second each time then you probably don't have an issue.
Ah, careful now. ...
--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)

March 7, 2022 at 9:45 pm

#3995319
Reply To: Restore SQL databae

Apparently, this isn't an urgent problem, eh?
--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)

March 7, 2022 at 6:07 am

#3994583
Reply To: Can't Import File

I think the following error line from those that you provided is the key hint as to what is wrong...
Error 0xc02020c5: Data Flow Task 1: Data conversion failed while converting...
--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)

March 7, 2022 at 6:01 am

#3994576
Reply To: What is SQL & how it wordk

Just try asking that same question on Google or any search engine. It's a common question and there are a shedload of excellent articles on the subject.
--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)

March 7, 2022 at 5:52 am

#3994569
Reply To: Does SQL 2012 support computed fields?

Ah, be careful now. If you use a formula for the backbone of your computed "field" (they usually referred to as a computed or calculated "column") and it has any...
--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)

March 7, 2022 at 3:38 am

#3994506
Reply To: performance question

Bruin wrote:
I did want to mention that this machine is a 2 node(8 cores per) machine and the Cost Threshold for Parallelism is set to 50. Maxdop on server basis...
--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)

March 7, 2022 at 2:59 am

#3994494
Reply To: Lots of data + HierarchyId performanceproblems

oRBIT - I finally figured some stuff out and used and old example of a small hierarchy and converted it to HIERARCHYID. The "ID" column in your table is 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)

March 5, 2022 at 11:26 pm

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

Steve Collins wrote:
Jeff Moden wrote:
I have a fellow that's trying to resolve some performance issues in a HierarchyID-based table. I just don't use HierarchyID because I've found or made better ways 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)

March 5, 2022 at 11:20 pm

#3994077
Reply To: sum equally distributed by date

@shree23 ,
Thank you for trying but you posted no image of expected results like your post says you did and I know for sure that you didn't even try your...
--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)

March 5, 2022 at 7:53 pm

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

I have a fellow that's trying to resolve some performance issues in a HierarchyID-based table. I just don't use HierarchyID because I've found or made better ways to work 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)

March 5, 2022 at 3:25 am

#3993524
Reply To: Lots of data + HierarchyId performanceproblems

oRBIT wrote:
I wonder if there might be some kind of workaround here.. Could I temporary transform the data (quickly obviously) in some way that makes calculations faster?
I doubt some recursive...
--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)

March 5, 2022 at 3:12 am

#3993519
Reply To: Is the Time of the DBA Ending?

I think you’ve pretty much hit the nail on the head, Steve. My perception (which could be incorrect so correct me if I'm wrong) of what you said is that...
--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)

March 5, 2022 at 2:45 am

#3993508
Reply To: Extract date from a text field

ScottPletcher wrote:
I still don't get your insistence on the guid being so always great as the clustering key for a table.
As a stand-alone table, maybe, IF all the rows inserted...
--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)

March 3, 2022 at 10:22 pm

#3992710

Viewing 15 posts - 3,796 through 3,810 (of 59,067 total)