So...

We "talked" on LinkedIn.  I provided a link to "BULK INSERT" and introduced "BatchSize" and "Tablock" to you.  You also found "Example f.", which is about how to do things...

I have to admit, I'm totally amazed about the number of people that participate on the QoD and on Polls on linked in.

I'm also amazed at the number of wrong...

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