Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 59,082 total)

Reply To: LOJ followed By LOJ - What is this and is it best practices

No. I don't avoid it. I never write things that way but I don't change them if I come across them. As you say, it doesn't cause any issues except...
--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)

February 14, 2023 at 10:39 pm

#4149808
Reply To: LOJ followed By LOJ - What is this and is it best practices

The only time I've seen one like that is when someone use the "Query Builder" functionality and only in what I refer to as a "Skip Join" where Table 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)

February 14, 2023 at 7:18 pm

#4149686
Reply To: PIVOT, is there a better way to do this?

ARPRINCE wrote:
ScottPletcher wrote:
ARPRINCE,
Have you looked at the query plans for the two queries? The LEFT JOIN method is doing a full table scan per join. That could be a (big)...
--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)

February 14, 2023 at 4:37 pm

#4149611
Reply To: options for querying external data sources from SQL Server

Be careful of "old" tutorials on this one. They HAVE changed it, especially starting in 2019 (according to the MS documentation) and some of the "old" methods may no longer...
--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)

February 14, 2023 at 4:34 pm

#4149609
Reply To: Dealing with super huge table which is partially partitioned.

Interesting... the first time I clicked on it, it took me to a page selling hair-care products with that picture on it. I just clicked on it again and, 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)

February 14, 2023 at 4:30 pm

#4149593
Reply To: Dealing with super huge table which is partially partitioned.

Jonathan AC Roberts wrote:
It is just a link that has the same photo as the avatar of person who posted the message taken from ChatGPT.
I'm thinking that may have been their goal...
--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)

February 14, 2023 at 3:16 pm

#4149573
Reply To: Dealing with super huge table which is partially partitioned.

Grant Fritchey wrote:
If you've been running without partitions for 12 years or so, why add them back? Partitions are all about data management, not performance. If you're not dealing with all...
--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)

February 14, 2023 at 3:10 pm

#4149570
Reply To: Need to do a mass update - taking days

@krypto69 ,
Thank you for the DDL. I'll take a look at that and your code tonight after work tonight.
Just to double check after a quick scan... I see no Clustered...
--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)

February 14, 2023 at 3:05 pm

#4149568
Reply To: Dealing with super huge table which is partially partitioned.

Jonathan AC Roberts wrote:
wrote:
Dealing with a super huge table that is partially partitioned can be a challenging task for many database administrators and developers. However, with the right approach and tools,...
--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)

February 14, 2023 at 3:02 pm

#4149565
Reply To: help on extended event session

vsamantha35 wrote:
Want to know whether it is randam insert guid is causing the problem
If it is and you're concerned about the page splits (I usually am because they can cause...
--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)

February 14, 2023 at 2:56 pm

#4149546
Reply To: What is ChatGPT – Is it the rise of the Skynet era?

Heh... not exactly SkyNet yet but, first drones and now this... and, guess what? It doesn't have to eat or pee. 😀
https://finance.yahoo.com/news/an-ai-agent-flew-a-usaf-training-aircraft-for-over-17-hours-185930689.html

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

February 14, 2023 at 2:30 am

#4149316
Reply To: What is ChatGPT – Is it the rise of the Skynet era?

Jonathan AC Roberts wrote:
Here is my attempt:
...{snip}...
That worked and is reasonably efficient.
One of my other issues with these 'bots is that they don't provide many choices. When I ask a question 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)

February 14, 2023 at 12:28 am

#4149292
Reply To: options for querying external data sources from SQL Server

pietlinden wrote:
oh, right. That's the part I was going to try to avoid: SSIS.
Totally understood and agreed but, YOU asked! 😀 😀 😀
First, and to set the record straight, 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)

February 13, 2023 at 11:59 pm

#4149274
Reply To: Need to do a mass update - taking days
1. Please provide the complete CREATE TABLE statement for the dbo.Member table. This must include all constraints, keys, indexes, and FKs that may be pointed at the table for 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)
February 13, 2023 at 11:20 pm

#4149269
Reply To: options for querying external data sources from SQL Server

pietlinden wrote:
(Kinda wish MSFT would do something like the PowerBI import/link kind of UI for SQL Server... but that's wishful thinking on my part, I'm sure!)
Most people would tell you...
--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)

February 13, 2023 at 10:03 pm

#4149248

Viewing 15 posts - 1,921 through 1,935 (of 59,082 total)