Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,841 through 3,855 (of 59,087 total)

Reply To: Creating Primary Column(Key) & Remove Duplicates

yrstruly wrote:
Duplicates involves all columns. I would like to add an index column to identify each row.
If that's the case, then perhaps create a persisted computed consisting of a formula...
--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)

March 3, 2022 at 6:24 pm

#3992643
Reply To: Creating Primary Column(Key) & Remove Duplicates

yrstruly wrote:
First i would like to able to have an unique identifier. Is the unique index the way to go?
Would you answer my question about the dupes, please? And, if...
--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)

March 3, 2022 at 4:58 pm

#3992585
Reply To: too much slow when check long wrong query i found status suspend with wait
Sure. Your join condition is as follows...
```
ON nr.AcceptedValuesOptionID = m.ShelfLifeConditin
```
Do you have indexes on both of those columns? Probably not especially since one of the tables 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)
March 3, 2022 at 12:02 am

#3992032
Reply To: Extract date from a text field

Just to be sure, you didn't upset anyone. I'm just amazed that people don't do more on their posts to help others actually know enough to help them. For future...
--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)

March 2, 2022 at 11:00 pm

#3992012
Reply To: Creating Primary Column(Key) & Remove Duplicates

It currently looks like a "dupe" involves all of the columns that you posted. Is that correct?

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

March 2, 2022 at 7:33 pm

#3991946
Reply To: too much slow when check long wrong query i found status suspend with wait

Try running an "Estimated Execution plan on that". I'm thinking that the join condition is inadequate and has caused a huge and terrible CROSS JOIN.
--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)

March 2, 2022 at 6:37 pm

#3991920
Reply To: performance question

Bruin wrote:
Hope I caught all replies, I'm going with having ORM fix code as suggested..
You didn't. And while I agree that ORM code frequently needs to be fixed, it's probably...
--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)

March 2, 2022 at 6:11 pm

#3991892
Reply To: Extract date from a text field

Even after participating in forums for more than 2 decades I guess I'll never understand why people post and then never answer a simple question asking a a small example...
--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)

March 2, 2022 at 6:02 pm

#3991883
Reply To: Automatically output Extended Events data to table

mg_dba wrote:
You are probably right Jeff, the actual use case is to log specific query executions to a table...but now you've got me thinking of other potential ways...🤔
It's partly 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)

March 2, 2022 at 5:25 pm

#3991858
Reply To: performance question

It would be really helpful if you could include an ACTUAL Execution Plan (as opposed to an Estimated Execution Plan). See the article at the second link in my signature...
--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)

March 2, 2022 at 5:20 pm

#3991855
Reply To: Help with proper indexes

railman wrote:
My current plan is to keep the ID field and my current indexes because it is working fine.
Then I will probably make a copy of the table and try...
--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)

March 2, 2022 at 5:05 pm

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

Grant Fritchey wrote:
Jeff Moden wrote:
I normally do try. I even violated my own decision to "black ball" someone last night and tried to figure out what the heck it was they were...
--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)

March 1, 2022 at 8:20 pm

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

I normally do try. I even violated my own decision to "black ball" someone last night and tried to figure out what the heck it was they were talking about. ...
--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)

March 1, 2022 at 5:12 pm

#3991242
Reply To: Automatically output Extended Events data to table

I've found that a lot of people are using XE to do a lot of things that SQL Server already does better than you could do it with XE. With...
--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)

March 1, 2022 at 5:04 pm

#3991233
Reply To: Parsing XML data to table
Mark Cowne wrote:
Another way
SELECT C.x.value('@Id', 'varchar(20)') as Id
,C.x.value('@ChapterName', 'varchar(20)') as ChapterName
,C.x.value('concat(local-name(parent::*/parent::*),"\",local-name(parent::*),"\",local-name(.)) ', 'VARCHAR(1000)') AS [Path]
FROM @doc.nodes('ROOT/*/*/item') as C(x)
You've helped a great number of people with sometimes some...
--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 28, 2022 at 10:12 pm

#3990761

Viewing 15 posts - 3,841 through 3,855 (of 59,087 total)