Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 59,067 total)

Reply To: The External Pushdown

I had no clue but, when I did a search for it, It thought it was hilarious (or, more likely, hilari-ass) that one of the items returned on the first...
--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 16, 2022 at 9:10 pm

#4114032
Reply To: Typical SQL interview questions for Data Analysts?

I'm pretty sure this a spam post. The exact same question was posted on Reddit a month ago. It's looks like the ol' one question from login and answer 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)

November 16, 2022 at 8:47 pm

#4114013
Reply To: Are there performance bottlenecks on Azure (Free Trial)

Weegee71 wrote:
Now this is a massive jump from a local instance running on my laptop (core i5, 8 gb RAM) to a database on Azure free trial
Welcome to the world...
--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 16, 2022 at 8:38 pm

#4114012
Reply To: Are there performance bottlenecks on Azure (Free Trial)

Scott Mildenberger wrote:
An Azure Database with 10 DTU's is the second lowest size available, up the size and try again.
He's using the "free trial" version... can you actually up the DTUs...
--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 16, 2022 at 8:36 pm

#4114010
Reply To: Tutorial to Create a Power BI Report Using PostgreSQL

Will the real Robert Sterbal please stand up?
--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 16, 2022 at 7:45 pm

#4114000
Reply To: Fault-finding unexpected data changes

Cascading triggers?
--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 16, 2022 at 7:18 pm

#4113986
Reply To: Introduction

Greetings and welcome aboard.
Just to "grease you up" for asking questions, I recommend you read and understand the article at the first link in my signature line below. If 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 16, 2022 at 7:16 pm

#4113985
Reply To: Tutorial to Create a Power BI Report Using PostgreSQL

Robert Sterbal wrote:
Thanks.
For the first time in a long time I actually have a database that needs indexing. I imported about 9 million voter records from the Pennsylvania Full Voter Export.
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)

November 16, 2022 at 4:52 pm

#4113867
Reply To: Saving transaction backup logs off the DB server

So, what happens if someone needs a restore from the previous day 30 seconds after you drop the old backup?
It sounds to me like you need to keep both 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)

November 16, 2022 at 4:49 pm

#4113865
Reply To: First wednesday of February & August Every year

SwePeso wrote:
Because if you care about performance, you want to avoid IO. Calculating "next wednesday" is about 150 times faster than looking it up (using ta table) on just 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 15, 2022 at 9:04 pm

#4113456
Reply To: Saving transaction backup logs off the DB server

And don't forget to make "compression" the default... especially when using a NAS.
--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 15, 2022 at 6:02 pm

#4113407
Reply To: Pivot Issue

Ok... this is the 3rd post on the same subject. One of your others provided some output, one of the others provided some input, and this one provides 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)

November 15, 2022 at 4:57 pm

#4113350
Reply To: Pivot Issue

You'll find that very few people are going to go read the article you provided a link to. You also haven't posted the full code you're using . You've also...
--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 15, 2022 at 4:55 pm

#4113348
Reply To: Sql Column value dyncamically

I see no difference between the original data form and what you've requested. other than some column names in the desired output. We don't actually know what the column names...
--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 15, 2022 at 4:49 pm

#4113346
Reply To: Saving transaction backup logs off the DB server

Saving either the full backups or the log file backups to the same server as the database is one of the worst ideas for backups. There's no chance at restores...
--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 15, 2022 at 4:43 pm

#4113344

Viewing 15 posts - 2,446 through 2,460 (of 59,067 total)