Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,771 through 1,785 (of 59,067 total)

Reply To: RIGHT-JOIN table not fetching all rows in WHERE clause

Neil Burton wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
I can't say I have ever used RIGHT JOIN. I think it is only in the language for completeness.
I use it a fair bit in real life.
Why...
--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)

March 6, 2023 at 4:12 pm

#4157335
Reply To: RIGHT-JOIN table not fetching all rows in WHERE clause

Jonathan AC Roberts wrote:
I can't say I have ever used RIGHT JOIN. I think it is only in the language for completeness.
I use it a fair bit in real life.
--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)

March 6, 2023 at 3:01 pm

#4157316
Reply To: Need to add columns to table from lookup to 2 other tables

You've posted delimited data. Take it to the next step and post it as readily consumable data and you might get better answers because more people will give it 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)

March 6, 2023 at 3:00 pm

#4157303
Reply To: update stats vs rebuilding indexes

Just in case you need to fight off the folks that still think that regular index maintenance based on logical fragmentation is a good idea, Microsoft finally "got the word"...
--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)

March 5, 2023 at 8:19 pm

#4157054
Reply To: Code to sum hours and minutes (varchar), 800,000 rows.

Then the derivative code from SwePeso's post will correctly return the total number of decimal hours for you. You only think his code was complex because he included test 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)

March 5, 2023 at 7:55 pm

#4157052
Reply To: Code to sum hours and minutes (varchar), 800,000 rows.

Teewhy wrote:
Secondly, the data was imported from excel in hh:mm format but it is coming up in sql as varchar.
Understood... Such a statement generally means that no value will be...
--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)

March 5, 2023 at 6:28 pm

#4157044
Reply To: waittypes in sql server

So... lemme get this straight... you actually have a 4.1 TERAbyte TempDB??? This suggests to me that your code has some real problems and that you grew tempdb to 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)

March 5, 2023 at 12:06 am

#4156921
Reply To: High cpu usage on Always on

Jeffrey Williams wrote:
ramana3327 wrote:
Michael is correct, We don’t have readable secondary. I don’t think adding more resources to the physical box is easy as VM.
I read through this - and seriously,...
--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)

March 4, 2023 at 11:31 pm

#4156915
Reply To: update stats vs rebuilding indexes

Michael L John wrote:
vsamantha35 wrote:
For question #1, just do a test. I think that you'll find that the stats take a lot longer because Index Rebuilds only affect/rebuild the columns they actually...
--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)

March 4, 2023 at 11:04 pm

#4156913
Reply To: The Top SQL Server Engine Errors

Good Lord... I don't know why I went and read some of the resolutions for this list but thanks for bringing it up, Steve.
Read the "Resolution" section for the 3rd...
--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)

March 4, 2023 at 3:34 pm

#4156860
Reply To: Why do cloud companies (in particular) have massive SKOs every year?

Heh... what'd I tell ya? Prelude to SPAM. 😀
--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)

March 4, 2023 at 12:14 am

#4156673
Reply To: SQL - Grouping SQL output in 5 minute intervals

aitorzur@hotmail.com wrote:
Modified to do the group by using the "Timestamp_datetime" field in case someone has the scenario where the time stamp is not already available as a seconds value. 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)

March 3, 2023 at 11:34 pm

#4156663
Reply To: SQL 2016 updates

Aye... thanks for the feedback. I've been mostly left out of the update loop at work. They've got a corporate mandate and it's the Infrastructure Group that takes care of...
--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)

March 3, 2023 at 11:17 pm

#4156659
Reply To: Dropping Columns

Heh... it's still going to be 2 batches... one for the drops and 1 to recover the space that wasn'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)

March 3, 2023 at 3:17 pm

#4156517
Reply To: The Struggles to Keep Up with Growing Systems

NM
--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)

March 3, 2023 at 1:09 am

#4156221

Viewing 15 posts - 1,771 through 1,785 (of 59,067 total)