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...
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...
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...
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...
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...
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...