Viewing 15 posts - 1,546 through 1,560 (of 3,232 total)
OK, then let's build out a test case to reproduce the problem. Can you post some sample data of rows that were successfully updated and some that were not...
November 3, 2008 at 12:38 pm
4686 before the script is run, just as I said
Then your code should go through 4686 iterations, one for each row. If you are left with rows with NULL...
November 3, 2008 at 10:31 am
When you say, 'I have xxxx records', do you mean that this is the count of rows that match the IS NULL criteria in your cursor?
Any ideas? - it's hard...
November 3, 2008 at 9:54 am
Yea, Garadin is correct. You need a second FETCH statement in your while loop. Also, something doesn't look right to me here. Your code does an update...
November 2, 2008 at 3:14 pm
That's the problem then. If you've written your stored procedure to only insert one row at a time, you are stuck with RBAR unless you re-create the SP to...
October 31, 2008 at 2:24 pm
So you are looking for a stored procedure that can do a set based insert into one table from another. Quickly to you means good performance?
Here's an example of...
October 31, 2008 at 2:17 pm
Can you explain what you mean by 'quickly call' the SP? The code for inserting from one table to another is simple so I'm a bit stuck here as...
October 31, 2008 at 1:58 pm
Well, you need some way to make sure the data does not exist in the target table prior to inserting it. You could accomplish this by using an IF...
October 31, 2008 at 1:29 pm
I am a bit confused as to what the problem is here. Can you explain a bit more on what your stored procedure is doing?
October 31, 2008 at 1:09 pm
Well, this is a bit out of the box and I've not done this before, but it may be an option for you to try. You may be able...
October 31, 2008 at 12:54 pm
Is this a production DB? If so, you'll want to wait for down time to run the BACKUP LOG command with TRUNCATEONLY. Unless, of course, you don't care...
October 31, 2008 at 12:32 pm
Once you've backed up the log, you should be able to use DBCC SHRIINKFILE() on the log file. This will reduce the physical size of the log. How...
October 31, 2008 at 12:25 pm
Good explanation of the self-blocking processes. Also, for your deadlocks, here's a good link to help :http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/tracingdeadlocks/1324/
October 24, 2008 at 1:25 pm
Viewing 15 posts - 1,546 through 1,560 (of 3,232 total)