Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 59,067 total)

Reply To: TOP with Order By alternative, performance results look mixed

The real problem is that even the "Actual" execution plan is riddled with estimates and the % of Batch junk is the worst. It's pretty easy to create a couple...
--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 8, 2023 at 6:03 pm

#4207222
Reply To: how to determine if we can delete the index can be removed

I'll recommend that you can mitigate risk by (as previously stated) first making sure that the index is not a unique index and ,second, just disabling the index and see...
--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 7, 2023 at 2:30 am

#4206035
Reply To: Display columns from multiple rows in single

Steve Collins wrote:
Is the QUOTENAME to make the sample data? 🙂
Yes... the QUOTENAME is supposed to be used just to make the sample data and isn't required to be posted. 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)

June 7, 2023 at 1:55 am

#4206011
Reply To: Display columns from multiple rows in single

If you want better help, please post your example data as "Readily Consumable" data instead of a graphic. 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)

June 5, 2023 at 9:00 pm

#4205057
Reply To: Bing Chatbot vs ChatGPT

All that hype and it still produces incorrect answers to simple SQL questions that won't even execute. And, it's method of posting (in one case) 30 different links to things...
--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 5, 2023 at 8:30 pm

#4205042
Reply To: Trust!

My Dad told me when I was quite young that "Half of all that is written is wrong and the other half is usually written in such a fashion 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)

June 3, 2023 at 3:15 am

#4203414
Reply To: How do you Sprint?

Lordy... such companies exist but, man, they're very rare. Most companies are like the one you speak of... they've adopted a horribly misshapen, grossly incorrect, interpretation of what "Agile" is...
--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 2, 2023 at 5:37 pm

#4203175
Reply To: Not wanting to use a Cursor, but...

Since you're new, please see the article at the first link in my signature line below if you want tested code. For me, it's super rare for me to post...
--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 2, 2023 at 2:03 am

#4202677
Reply To: NOT LIKE Alternatives in WHERE clause

That's a great idea, Jonathan. Unfortunately and as the OP revealed in the post at the link below, the reasons aren't quite that simple.
https://www.sqlservercentral.com/forums/topic/not-like-alternatives-in-where-clause#post-4200971
--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 1:39 am

#4201901
Reply To: Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?

Isn't this a job for "Replication"? IIRC, it can even update the meta data in the target to match that in the source.
--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:56 am

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

Viewing 15 posts - 1,396 through 1,410 (of 59,067 total)