Jeff Moden

Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 59,099 total)

Reply To: How to Efficiently Find and Remove Duplicates in a Large SQL Database?

Piyushbhatt wrote:
I have a large SQL database with millions of records, and I've identified duplicate entries. What's the most efficient way to find and remove these duplicates without compromising 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)

November 10, 2023 at 12:28 pm

#4325149
Reply To: how to reverse comma seprated values.

Phil Parkin wrote:
Thanks, Jeff. I made the assumption that the OP did not have a table 'TBL' containing a single column 'COLUMN1' and therefore that the addition of a suitable PK...
--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)

November 10, 2023 at 12:16 pm

#4325148
Reply To: how to reverse comma seprated values.

rajemessage 14195 wrote:
hi,
i have coma separated vales in a table. what i want to reverse it like 'CLP,CAD,GBP' pls tell me how it can be done WITH OUT USING XML 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)

November 10, 2023 at 11:44 am

#4325138
Reply To: Changing the PK - I

Great question, Steve. It gave me an idea for something else that I need to do.
--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)

November 8, 2023 at 8:17 pm

#4323998
Reply To: IX fragmentation and Updating Stats

sqlguy80 wrote:
Though its Azure MI Business critical , I see fragmentation, Any script to identify which IX's need to be rebuilt ,as Frag is over 50%.
I will add REBUILD 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)

November 7, 2023 at 8:08 pm

#4323270
Reply To: shrink data file with low priority

Jeffrey Williams wrote:
Or - you could add a file and use EMPTYFILE on the original file. Once the original file is empty it can then be removed.
Have you tried this when...
--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)

November 6, 2023 at 11:34 pm

#4322599
Reply To: shrink data file with low priority

Removed... I somehow duplicated the post 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)

November 6, 2023 at 11:33 pm

#4322598
Reply To: The SQL Server Windows NT - 64 bit" in Task Manager: memory high 10 gb cpu 100 %

Grant Fritchey wrote:
Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be 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)

November 5, 2023 at 8:51 pm

#4321802
Reply To: Replacing last few characters with another value.

"Bumping" this post because it's hidden by the "Don't display the first post of a new page" problem this forum has, which I wish they'd fix. This has been 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)

November 4, 2023 at 10:27 pm

#4321317
Reply To: Convert columns result into rows with comma and single quotes

The issue with using QUOTENAME is that it returns the result as an NVARCHAR(258). The OP started out with a VARCHAR().
In this case, the resulting STRING_AGG() returns an NVARCHAR(4000).
--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)

November 4, 2023 at 10:14 pm

#4321316
Reply To: Newly created login can not see/connect to user database

Just "bumping" this because of the "1 Post on another Page won't display" problem that this forum has. I really wish they'd fix this issue. 🙁
--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)

November 4, 2023 at 10:03 pm

#4321315
Reply To: extended events not showing events

robh0502 wrote:
thanks all. Seems to be working now.
What did you change to make it so?
--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)

November 4, 2023 at 9:47 pm

#4321314
Reply To: A rose by any other name would not be a rose

Heh... what? You don't like using D1, D2, D3, D4, etc, for the names of cascading CTEs? 😛 Or, how about table aliases named T1, T2, T3, T4, etc?
I've seen...
--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)

November 4, 2023 at 4:24 am

#4320869
Reply To: Trigger to track changes

sqlguy80 wrote:
I need to track changes when a column is updated on two tables.
Is there a way to do it. please send code for that.
Yes... there's a super easy way...
--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)

November 2, 2023 at 11:40 pm

#4320062
Reply To: Need help with the logic

Not that the code is unreadable or anything like that but consider documenting your production code so people don't have to try to figure out what the intent of 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)

November 1, 2023 at 7:02 pm

#4319190

Viewing 15 posts - 991 through 1,005 (of 59,099 total)