Tag Info

New answers tagged


If your first test showed a problem, assume that there is a problem! Problems don't just disappear on production, even if you have the best possible theory for their existence, you still need to test. BCP copy should be using row-level locks by default. Which should escalate to page-level locks due to the size of your data. If despite these locks, you are ...


I got it to work. Your varbinary data must be in form 424C4F4220434F4E54454E54 in csv file. And you also must specify the right code-page of the csv file. I have the following table: CREATE TABLE [dbo].[BlobTable]( [id] [int], [blobValue] [varbinary](max), [textValue] [nvarchar](500) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] and bulk import ...

Top 50 recent answers are included