Viewing 6 posts - 1 through 6 (of 6 total)
Oh yea, absolutely. For the most part, I only use loops when I'm doing mass updates or for copying/moving large sets of data from one database table to another...
February 18, 2011 at 8:01 am
That's right. The last time I updated our server for the new control, it was included as part of a security update. The changes in the control version...
February 18, 2011 at 7:21 am
Derrick,
Yes, you are correct. I did some testing comparing a read_only static forward_only cursor to the loop method. At first the cursor was executing in 1/4 the time...
February 17, 2011 at 6:34 pm
The truth is you don't NEED cursors. I'm confident that any query you want to perform can be done without the use of cursors. I have done performance...
February 17, 2011 at 11:55 am
These are rule of thumb recommendations I followed from a SQL Server analyst we hired to help with a very large high performance database we implemented. OS should be...
February 17, 2011 at 10:40 am
Make sure both web servers are updated with the latest patch. The server includes a print control that is downloaded to the web browser. This control needs to...
February 17, 2011 at 9:28 am
Viewing 6 posts - 1 through 6 (of 6 total)