Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,506 through 2,520 (of 59,067 total)

Reply To: SSMS csv export file is missing leading zeroes for Numeric data types

I have to ask... why is it important to have leading zeros on this particular bit of numeric data in the CSV? Or is it not a CSV file after...
--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 9, 2022 at 6:33 pm

#4110666
Reply To: Auto assign Column Data Types for Flat file Source Import

I agree that this is a great solution and some fine "out of the box" thinking for SSIS.
My problem with it all though is, you already know what the definition...
--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 9, 2022 at 3:55 am

#4110319
Reply To: Analyzing a huge ( more than 10600 lines )stoc proc using cte

Peel one potato at a time. Like Ratbak suggests above, it will require a "Diligent Data Engineer". One of the best things to make as you go along, 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)

November 9, 2022 at 3:43 am

#4110317
Reply To: DevOps is Culture

Eric M Russell wrote:
DevOps is a collection of tools and processes for deploying code.
IMHO... that's what the word has come to mean but not for me. You can have all the tools...
--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 8, 2022 at 6:59 pm

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

I'm thinking that they've stretched Steve a bit too far... I can't even get an acknowledgment to the two emails that I've sent the WebMaster about the email notifications.
--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 7, 2022 at 7:22 pm

#4109744
Reply To: DevOps is Culture

I guess DevOps has degraded to the point where you can't even get an acknowledgement to a site problem sent to the WebMaster because there's too much DevOps going on,...
--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 7, 2022 at 7:15 pm

#4109743
Reply To: SAP S/4HANA and Microsoft Azure SQL integration and ETL DELTA Process

This isn't the place to post an article. This is a thread for people to request articles or post article ideas. Hopefully, though, the WebMaster will see this and respond...
--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 5, 2022 at 9:45 pm

#4109138
Reply To: Extracting first characters in a string

Jonathan AC Roberts wrote:
Jeff Moden wrote:
As a bit of a sidebar, you may have some people come back with a suggestion of using the built-in STRING_SPLIT() function. That will seem to work but...
--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 5, 2022 at 8:28 pm

#4109122
Reply To: How to remove diamond character from string in sql

At McFarlandParkway,
Are you all set? Did the solution I posted work for you?
--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 5, 2022 at 8:26 pm

#4109121
Reply To: full name splitting based on the condition

@Sathish,
Are you all set? If not, take a look at the article at the first link in my signature line below to learn how to post some "Readily Consumable 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)

November 5, 2022 at 8:24 pm

#4109120
Reply To: Why does a select on 1 table end up putting locks on other tables?

@Tobar... did you ever figure this out? Without being able to put my hands on the database, I'm out of suggestions.
--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 5, 2022 at 8:22 pm

#4109119
Reply To: Sql subquery poor perf - Need to rewrite to optimise

DesNorton wrote:
Assuming that all of the other 20 subqueries are based on the same pattern in tblPolSpec, you will probably get better performance if you use a CROSS-TAB query like...
--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 5, 2022 at 7:44 pm

#4109112
Reply To: Sqlagent data transfer issue

Blokeandbird wrote:
Many thanks for your help. I have been told that it uses DTExec.exe to run the SSISpackage. I am trying to find out more about this but if anyone...
--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 5, 2022 at 7:43 pm

#4109111
Reply To: Datafile full, but it isn't a table

Memory optimized?
--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 4, 2022 at 6:34 pm

#4108830
Reply To: Sql subquery poor perf - Need to rewrite to optimise
The original code looks like a "poor man's CROSSTAB". Try the following true CROSSTAB instead.
```
 SELECT  PolNr = m.PolNr
       ...
```
--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 4, 2022 at 6:14 pm

#4108806

Viewing 15 posts - 2,506 through 2,520 (of 59,067 total)