Jeff Moden

Forum Replies Created

Viewing 15 posts - 481 through 495 (of 59,091 total)

Reply To: We Stink!

Ok... talk about stink! Fortunately, they decided not to chance using a faulty space craft (IMHO, it was faulty even at lift off) but check this out.
https://weather.com/science/space/video/astronauts-stranded-in-space-with-no-return-set
https://duckduckgo.com/?q=astronauts+stuck+in+space+2024+boeing
They should jettison 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)

July 27, 2024 at 9:23 pm

#4440432
Reply To: We Stink!

Nope... not "WE"... "THEY".
THEY have gotten arrogant... every damned one of them.
--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)

July 27, 2024 at 4:59 am

#4440313
Reply To: How To Approach Adding A primary Key To An Existing Table

I agree with Brian... check with the 3rd party before you mess with one of their tables. While this is just a simple "audit" table that won't even 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)

July 25, 2024 at 11:01 am

#4439768
Reply To: How to get a distinct value from my data set

Do a COUNT on both columns using GROUP BY and add a HAVING where the COUNT(*) = 1.
--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)

July 25, 2024 at 5:07 am

#4439720
Reply To: Thinking About Technology

I saw the follow soon after it came out more than a year ago. It's focus is on the very ramifications you speak of... in this case, something as seemingly...
--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)

July 24, 2024 at 3:52 am

#4439418
Reply To: SQL 2022 performance

Heh... New tag line... SQL Server 2022... It just runs slower... A LOT SLOWER!
--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)

July 22, 2024 at 9:28 pm

#4438969
Reply To: Creating an Index with a lot of Columns

Johan Bijnens wrote:
Jeff Moden wrote:
emuller1982 wrote:
After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was...
--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)

July 19, 2024 at 7:49 pm

#4438411
Reply To: Where to Test Your Code

Rod at work wrote:
That is really awesome, Jeff! In fact, that's outstanding. In my environment we do unit testing and UAT, and that's about it. We don't have the success rate 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)

July 19, 2024 at 3:38 am

#4438186
Reply To: Code does Not Read in FY 2025 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)

July 18, 2024 at 5:59 am

#4437805
Reply To: SQL Saturday Pittsburgh 2024 (#1094) - Call for speakers and other event details

Steve Jones - SSC Editor wrote:
Hmmm, Jeff going. I'm going to have to see if I can make it.
Ed Wagner and I will be arriving in the afternoon on that Friday. Man, I understand...
--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)

July 18, 2024 at 5:00 am

#4437795
Reply To: Code does Not Read in FY 2025 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)

July 18, 2024 at 4:36 am

#4437794
Reply To: needing to insert 2 sets of numbers to a table to use as ranges for a query
Jonathan AC Roberts wrote:
Install this TVF.
Then this SQL will do the job
select x.value value1, x.value+1000001 value2
from dbo.GENERATE_SERIES(-999999999,+999999999,1) x
;
Jonathan AC Roberts wrote:
Install this TVF.
Then...
--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)
July 18, 2024 at 4:33 am

#4437793
Reply To: Creating an Index with a lot of Columns

emuller1982 wrote:
After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was killing 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)

July 18, 2024 at 4:24 am

#4437791
Reply To: Where to Test Your Code

I guess our code coverage is 500% plus a post prod kicker...
DEV
QA
DEVREVIEW (DBA Review and regression checks)
STAGE (UAT)
PREPROD (UAT and full system checks on full size from nightly restores which...
--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)

July 18, 2024 at 4:19 am

#4437790
Reply To: TSQL Help, Possible a recursive CTE

2nd page bump to get post to appear
--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)

July 16, 2024 at 4:41 am

#4436457

Viewing 15 posts - 481 through 495 (of 59,091 total)