sql server programming: Update -- sql server programming

Update

Bharat Khemka
1/11/2004 11:20:55 PM

sql server programming:

I have a VB/SQL application. Actually I have a few
different queries:

1. filename.ldf (auto log file) becomes very large say
upto 200MB sometimes while updating certain transactions
and sometimes it gives out of memory error. Please advise
how to handle this error?

2. I have used CURSOR for deletion of certain
transactions. Is there a way to stop CURSOR from
automatically executing certain transaction?

3. In my VB code, I am updating 20-30 different tables at
a time of SAVE, and this takes a lot of time upto 30-40
minutes. This is a single user application and even my
server machine is high end. Does it mean that I am doing
something wrong in my VB code while passing information to
update Tables? Please advise some remedy.

Thanks & Regards,
Bharat K.

Re: Update

Uri Dimant
1/12/2004 9:47:15 AM

Bharat
I assumend you have FULL or BULK-LOGGED recovery model on your SQL Server
So I f your data are critical for you and you would not want to loss it you
will have to backup log file (it also prevent the log for growing up in most
cases).On other hand you can set SIMPLE recovery model and it will be
truncated on peridiocal period ( I mean checkpoint will appeare every 5 min
as far as I remember)

Try to avoid using CURSORS because in most cases it is not necessary and
takes a lot of system resourses.

Should you really need to update these tables at time? Keep your tansactions
as small as possible.
Did you update tables by using SP or by sending SQL statement to the server
?

If you would provide more info about what are you doing so people may
suggest you solutions.

[quoted text, click to view]