Viewing 15 posts - 1 through 15 (of 16 total)
Sorry about not being clear earlier. It was trying to insert 10 million records.
October 30, 2011 at 6:32 pm
Thanks for the input. That is what I am thinking of doing - update in batches.
October 27, 2011 at 2:11 pm
What can be done in situations like these where a few million records will be inserted in the table? I only want 1 record to be inserted in the table...
October 27, 2011 at 11:19 am
I ended up doing something similar to this. Have a SP that looks for SPID running that command and then killing it (for now). In the meantime the developers are...
December 17, 2010 at 2:20 pm
Sorry for the confusion. In the snippet that I marked as "Want to Do -- This works" I was merely showing an example where using PATINDEX for the right side...
October 5, 2010 at 1:43 pm
Well using CUSTOMER_ID is one column they will use in the where clause. In actual scenario, the existing code may have a where clause for some other column - that's...
October 5, 2010 at 1:16 pm
Thanks all. That is what I will do...
October 5, 2010 at 1:04 pm
Thanks for your response. This particular bit of dynamic sql code was part of a much bigger part of dynamic sql infested code. I was able to get rid of...
October 5, 2010 at 11:34 am
I believe using TRIM() would give the following error:
Msg 195, Level 15, State 10, Line 3
'TRIM' is not a recognized built-in function name.
August 9, 2010 at 10:28 am
this is a great script. But it does not work if there are Included columns. Example my index looks like this:
CREATE UNIQUE INDEX IDX_indexName ON dbo.TableName
(
Column1
, Column2
)
INCLUDE
(
Column3
, Column4
, Column5
)
But...
June 5, 2008 at 2:39 pm
Text if message when I click on the Details Button:
See the end of this message for details on invoking
just-in-time (JIT) debugging...
November 14, 2005 at 1:01 pm
Thanks for your reply Remi.
You are right about the suggestion that we should have one table for all the data. Reason we cannot do that is for compliance issues and...
July 11, 2005 at 9:37 am
Thanks for Your reply,
A few issues though:
1: There are more than 150 item names in the real database and each run can have any number of items selected from 1...
June 6, 2005 at 8:31 am
We faced a similar situation sometime back when our company went or a spree to purchase a few other companies. We were assigned a task to come up with a...
June 6, 2005 at 8:25 am
Viewing 15 posts - 1 through 15 (of 16 total)