Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 59,069 total)

Reply To: ETL Best Practice - Need help and possible part time gig available
mrpaulytx wrote:
Forgot to mention a few more things:
1. Yes, we are planning to remove the link server. Very inefficient and unacceptable especially when joining to local data warehouse tables.
2. 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)
October 8, 2021 at 5:02 pm

#3938925
Reply To: Max of 2 columns gets sent to the third column (SQL)

kaj wrote:
I'm sorry about the misinformation. I didn't pay attention to the list of "Applies to" services.
I remembered some excited chatter some months ago about the functions now being available,...
--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)

October 8, 2021 at 3:55 pm

#3938903
Reply To: ETL Best Practice - Need help and possible part time gig available

ZZartin wrote:
Well if it's just a matter of copying data truncate and reload is easier to set up and maintain, volume permitting. Trying to capture deltas will but down 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)

October 8, 2021 at 3:49 pm

#3938902
Reply To: Need to use a script data source to pull in 10,000+ characters of data in one Excel column

sgmunson wrote:
Jeff Moden wrote:
sgmunson wrote:
I found this topic via a Google search, and it kinda-sorta relates to my issue. I need a Script Component in SSIS to serve as a 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)

October 8, 2021 at 3:13 pm

#3938891
Reply To: How to calculate Monthly aggregates from daily data

I'll try to post a solution tonight after work if no one else beats me to 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)

October 8, 2021 at 3:08 pm

#3938890
Reply To: Problems with date formats

Here are a couple of ways to do it. Like aadcock says above, format 23 comes into play. Be warned though... in a lot of languages, that format (23) will...
--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)

October 8, 2021 at 3:03 pm

#3938887
Reply To: Max of 2 columns gets sent to the third column (SQL)

I kinda figured. Thanks, for the confirmation.
After the performance issues included with the FORMAT function, I also worry about performance anytime MS comes out with a new function. I won't...
--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)

October 8, 2021 at 2:25 pm

#3938863
Reply To: Max of 2 columns gets sent to the third column (SQL)

kaj wrote:
In SQL Server 2019 you can also utilize the GREATEST function.
https://docs.microsoft.com/en-us/sql/t-sql/functions/logical-functions-greatest-transact-sql?view=sql-server-ver15
That documentation seems to suggest that it's only available on Azure instances and not "standalone" instances. Can someone 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)

October 8, 2021 at 2:03 pm

#3938858
Reply To: ETL Best Practice - Need help and possible part time gig available

As a bit of a sidebar and, like I said, only a quick look at the code you've attached, what is your complaint with the code?
--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)

October 8, 2021 at 1:53 pm

#3938842
Reply To: ETL Best Practice - Need help and possible part time gig available

Without spending much time looking at the code, my humble opinion is that it's usually easier and faster to truncate and reload if the full reload is available in 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)

October 8, 2021 at 1:38 pm

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

Just in case any of you use Twitch... it's been hacked.
https://www.theverge.com/2021/10/6/22712250/twitch-hack-leak-data-streamer-revenue-steam-competitor
--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)

October 8, 2021 at 1:21 pm

#3938826
Reply To: How to calculate Monthly aggregates from daily data

Jeff Moden wrote:
so here how can I change months data to weekly aggregate data for total counts.
Heh... maybe send me a coupon for a week's worth of of #8 Jimmy John's...
--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)

October 8, 2021 at 5:45 am

#3938702
Reply To: Need to use a script data source to pull in 10,000+ characters of data in one Excel column

sgmunson wrote:
I found this topic via a Google search, and it kinda-sorta relates to my issue. I need a Script Component in SSIS to serve as a data source for...
--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)

October 7, 2021 at 10:03 pm

#3938642
Reply To: log file of primary replica database is full

coolchaitu wrote:
There is no space for taking log backup
Ah... got it. Hopefully someone that uses AG might know why it filled up the log file and how to take care...
--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)

October 7, 2021 at 7:10 pm

#3938598
Reply To: replace chain of function calls with better code

If you're using this function against multiple rows in a query, there's no way that I'd leave it as a scalar function.
--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)

October 7, 2021 at 3:33 pm

#3938527

Viewing 15 posts - 4,486 through 4,500 (of 59,069 total)