I don't have enough details to know what is realy going on.

But even with recovery mode set to simple the transaction log will grow hughly during the transaction. Simple means...

Well, 48 hours seems to be an enourmous amount of time, even for 150.000+ records.

I suppose 'GenerateInserts' generates records with INSERT table(col, ...) VALUES (...,...)? Without any GO between them?

If...

First, make sure you use the BIDS Business Intelligence Development Studio.

If controls are missing you can allways right-click on the control box and select "choose items..."

If they don't show up...

Several ideas come to mind:

- why not create a linked server and load it from that?

- you could use BCP. This will allow you to control the batch size (-b...

Of course Grant, you are right, this would be the better way.

Suppose I was too much thinking database.

thanks,

Jan

I am considering using CLR for something that does involve data access and would value your opinions on that. We have a lot of stored procedures to analyze financial data....

nbryson,

I have a last suggestion before I give up.

It seems that the TRIM never works. It trims only blanks. Imagine that there is a nonprintable but not that is also...

It should give you the possibility to have a recordset out of your stored procedure that you still can manipulate:

select RTRIM(column) from openrowset(linkedserver, storedprocedure).

Of course, you have just created a new table with the same ANSI settings and ansi padding on.

I repeat this trick: a linked server to your own server and execute...

Yes, sorry I missed the fact that it is a stored procedure because there is not EXEC but that is not mandatory of course.

Just another idea if you really have...

Nickie,

Isn't there a part of your query missing: -q"dbo.systemwatchrun"?

Anyway, I would just use RTRIM's in the attributes. The padding with blanks has to do with your ANSI settings; but the...

Please don't post the same questions in multiple threads.

Sam,

Copy in

UPDATE dbo.TestData

SET binary_data = (SELECT binary_data FROM OPENROWSET(

BULK 'c:\temp\picture.jpg', SINGLE_BLOB) AS F(binary_data))

To copy...

Sam,

Copying in is a snap:

UPDATE dbo.TestData

SET binary_data = (SELECT binary_data FROM OPENROWSET(

BULK 'c:\temp\picture.jpg', SINGLE_BLOB) AS F(binary_data))

To copy the file out, before SQL2005...

I agree, we should have the possibility to post query plans here. But then again we should also know the indexes, datamodel, queries, even the whole analysis. It is just...

Hammad,

You should look at the data model, the query plan and the indexes and data distribution, and dbo.rap_fn_GetDuplicateListings. Just like this, this is a difficult problem for us to understand.

Jan