Jeff Moden

Forum Replies Created

Viewing 15 posts - 451 through 465 (of 59,063 total)

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
Reply To: TSQL Help, Possible a recursive CTE

erics44 wrote:
-- Create TableA CREATE TABLE TableA ( MainID INT, JoiningID INT );
-- Insert data into TableA INSERT INTO TableB (MainID, JoiningID) VALUES
(No column name)
...
Heh... you didn't try to run...
--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:36 am

#4436456
Reply To: Updated Table Not Displaying Data

yrstruly wrote:
Attached is some sample data. I could get this code to work, by inserting one row where FY/YEAR is 2024 and all of FY/YEAR 2025.
The original tables data goes...
--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:30 am

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

I'd rather go for a nice dinner and maybe some pool shooting at a good bar with big screens to watch the lions game than to get caught up in...
--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 3:41 am

#4436451

Viewing 15 posts - 451 through 465 (of 59,063 total)