This minor change (IIRC)...

BULK INSERT OSPRetail.dbo.DimProduct5
FROM 'C:\Users\User\Downloads\data feed.csv'
WITH ( FORMAT = 'CSV',
FIELDTERMINATOR = ',',
ROWTERMINATOR = 0X0A);

Also, read up a bit on the BULK INSERT and learn the...

Its managed SQL Server Business critical, with the latest version, and MS automated management of Log file.

The issue here is there is purge and archival of data creating lots...

Please...

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?