Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 59,082 total)

Reply To: Access db

I'm not sure that I understand your question but, at face value, I have to say that "It Depends" on the privs you give "the business", whatever that is defined...
--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)

June 1, 2023 at 12:52 am

#4201888
Reply To: NOT LIKE Alternatives in WHERE clause

BOR15K wrote:
Thank you, Jeff.
Much appreciated.
I just remembered a bit of trick code using "Cascading CTEs" that I did about a million years ago for the exact opposite of what you're...
--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)

June 1, 2023 at 12:40 am

#4201887
Reply To: Are the posted questions getting worse?

Dennis Jensen wrote:
So can anyone say have they turned the old Model-T into a futuristic hover car or at least a hybrid?
No. But consider that the Model-T still does exactly what...
--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)

May 31, 2023 at 2:08 am

#4201133
Reply To: NOT LIKE Alternatives in WHERE clause

BOR15K wrote:
1. Only #temp or ##temp tables.
2. Yes
3. Sadly no.
Massive thanks.
Heh... they really don't want this to be fast, do they? 😉
Instead of TempDB, how about a very small database...
--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)

May 31, 2023 at 2:00 am

#4201114
Reply To: NOT LIKE Alternatives in WHERE clause

BOR15K wrote:
Thank you, Jeff. The real data will have various reasons, but I need to exclude only three out of the rest. I can confirm now the pipe (|) can...
--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)

May 30, 2023 at 11:41 pm

#4201071
Reply To: NOT LIKE Alternatives in WHERE clause

BOR15K wrote:
Very valid point. No, there is no separator, but after having an internal chat, it may be possible to add a pipe (|) as a separator.
That would help for...
--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)

May 30, 2023 at 9:07 pm

#4200965
Reply To: NOT LIKE Alternatives in WHERE clause

Dennis Jensen wrote:
Jeff Moden wrote:
Do those reasons have a unique character that separates them? Your original post doesn't show one but I had to ask.
Ghads Jeff I know this is a quality...
--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)

May 30, 2023 at 9:05 pm

#4200964
Reply To: NOT LIKE Alternatives in WHERE clause

BOR15K wrote:
Thank you for the reply, yet I think it will not work if the reason column, as I mentioned in my original request, will have several concatenated reasons.
Do those...
--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)

May 30, 2023 at 6:33 pm

#4200899
Reply To: Triggers applied to primary and secondary tables causing rollback on primary

Just to be sure, a LOG or History or Audit or Temporal table should never have any triggers or constraints on it that evaluates data. Certainly, it should not 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)

May 28, 2023 at 4:22 pm

#4199411
Reply To: Are the posted questions getting worse?

Jonathan AC Roberts wrote:
Lynn Pettis wrote:
Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean it...
--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)

May 28, 2023 at 4:15 pm

#4199408
Reply To: Extracting multiple fields from one column

JeremyU wrote:
I cannot give DDL and sample data. Only that small part pretty much that I gave in the first message and yes, you are correct, I need to write...
--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)

May 26, 2023 at 9:02 pm

#4198408
Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

@Eirikur,
I keep looking at your timing results. You say the following...
Given the performance improvements gained by removing one REVERSE instance, I think we got some opportunities for improvement and more...
--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)

May 26, 2023 at 3:38 am

#4197823
Reply To: Upgrade to SQL2019 from 2012 and everything is slow - what to look for?

p.s. And, I agree... MS seems to follow a policy of "patch it until it breaks". 🙁 They're "It just runs faster" brag in 2016 broke some serious stuff for...
--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)

May 24, 2023 at 6:11 pm

#4196695
Reply To: Upgrade to SQL2019 from 2012 and everything is slow - what to look for?
@kevin Gill
EDIT: Sorry... I didn't read your last post where you said you've already tried the following.
The issue is, almost certainly, the changes they made to the Cardinality Estimator in...
- This reply was modified 3 years, 2 months ago by Jeff Moden. Reason: I didn't read your last post where you said you've already tried the following
--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)
May 24, 2023 at 5:59 pm

#4196691
Reply To: Query to Insert Data Based on CustomerID from one table to another

Jeff Moden wrote:
If you'd take the time to convert the data for BaseTable_A into a "Readily Consumable" format (please see the article at the first link in my signature line below...
--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)

May 24, 2023 at 2:29 am

#4196134

Viewing 15 posts - 1,426 through 1,440 (of 59,082 total)