Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 59,098 total)

Reply To: how to get quantity from yesterday 6pm till today 6pm

jcelko212 32090 wrote:
you now do groupings based on the timeslot name. No proprietary computations. Fast, simple joins. The ability to adjust your timeslots in the event of banking holidays.
Cool! Got...
--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 12, 2021 at 3:34 am

#3939646
Reply To: Log backup file is very large

The only reason I can see for doing such a thing is to have all the files since the last backup in one file especially for when it comes 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)

October 12, 2021 at 2:40 am

#3939642
Reply To: Requesting ideas for articles that might be of interest here

One of the best ways to find subjects to write about is to let them find you. You will have to start reading the best source in the world 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 11, 2021 at 7:19 pm

#3939581
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:
Just double checking... what's the target here... An Excel spreadsheet or a table? I'm pretty sure that it's not possible to do in a single blob in Excel.
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 7:06 pm

#3938968
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

Viewing 15 posts - 4,516 through 4,530 (of 59,098 total)