Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,461 through 2,475 (of 59,086 total)

Reply To: Issues with creating a foreign key

The error seems to indicate that the "idCategoria" column doesn't exist in one of the two tables. Check each of the two tables to make sure that the column does...
--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 19, 2022 at 11:45 pm

#4115383
Reply To: Introduction

Thanks for the feedback.
--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 9:34 pm

#4115072
Reply To: Hi Team

Jeffrey Williams wrote:
That all depends on the OP - and it isn't clear if they are looking for help with MySQL or converting from MySQL to SQL Server. If they are...
--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 9:32 pm

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

Viewing 15 posts - 2,461 through 2,475 (of 59,086 total)