Viewing 15 posts - 16 through 30 (of 66 total)
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...
May 17, 2007 at 9:45 am
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?
May 17, 2007 at 8:56 am
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...
May 17, 2007 at 8:30 am
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...
May 17, 2007 at 8:25 am
Of course Grant, you are right, this would be the better way.
Suppose I was too much thinking database.
May 17, 2007 at 8:08 am
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....
May 17, 2007 at 4:53 am
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...
May 16, 2007 at 9:10 am
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).
May 16, 2007 at 8:42 am
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...
May 16, 2007 at 8:00 am
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...
May 16, 2007 at 7:08 am
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...
May 16, 2007 at 6:41 am
Please don't post the same questions in multiple threads.
SET binary_data = (SELECT binary_data FROM OPENROWSET(
BULK 'c:\temp\picture.jpg', SINGLE_BLOB) AS F(binary_data))
May 16, 2007 at 1:48 am
Copying in is a snap:
To copy the file out, before SQL2005...
May 16, 2007 at 1:46 am
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...
May 16, 2007 at 12:50 am
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.
May 15, 2007 at 6:10 am