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

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

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

Great question, Steve.  It gave me an idea for something else that I need to do.

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

Have you tried this when...

Removed... I somehow duplicated the post below.

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

"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...

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

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. 🙁

What did you change to make it so?

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

Yes... there's a super easy way...

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