Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,476 through 2,490 (of 59,098 total)

Reply To: Challenging Yourself

call.copse wrote:
Jeff Moden wrote:
...
Then I proved the unthinkable... I made the 99% fragmented index twice as slow by [insert drum roll here] defragmenting it! That was a fortuitous accident that I...
--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 18, 2022 at 3:20 pm

#4114895
Reply To: Challenging Yourself

I have to disagree a bit with the opening quote in the article. My "wins" are learning episodes and so I'm always winning, not because I'm undershooting my potential, 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 18, 2022 at 6:22 am

#4114672
Reply To: Hi Team

I thought it was someone trying to convert some other dialect to SQL Server. 🙁 I wish people would declare things like that. Offering help in MySQL isn't a problem...
--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 18, 2022 at 3:08 am

#4114618
Reply To: Hi Team

ZZartin wrote:
If you want just the month name, SELECT FORMAT(getdate(), 'MMMM')
But ideally you would return the date as is and format it at display time.
You don't want to do 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)

November 17, 2022 at 7:02 pm

#4114482
Reply To: Introduction

In tha
Alxender wrote:
Thanks to all to welocome me. I hope , i'll gain more and more knowledge here.
In that case... Do you know what a "Tally" or "Numbers" table or...
--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 17, 2022 at 2:20 pm

#4114336
Reply To: Db is slow

bobrooney.81 wrote:
Hi SQL Gurus,
One of our production database is running very slow. I checked blocking , I didn't see any blocking. Also, check for running processes and look for 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)

November 17, 2022 at 7:28 am

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

Viewing 15 posts - 2,476 through 2,490 (of 59,098 total)