Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Load balancing Expand / Collapse
Author
Message
Posted Tuesday, September 29, 2009 2:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 11:24 AM
Points: 32,781, Visits: 14,942
Usually you do not want to do things in a looping manner in SQL Server. The db engine is optimized to do things with sets of data.

If you don't know how to move the code, or rewrite it, we can help with small snippets. However it's unlikely that many of us want to tune hundreds of lines of code for free. If you have a lot of code, and it is impacting your company, then I would suggest you talk with your boss and hire someone with more experience for a short term to both fix things and teach you more about SQL Server so you can better maintain the system. That is likely a better investment than a training class.

If you need to do this on an ongoing basis, I'd suggest you start reading more about SQL Server, and pick up the Inside SQL Server series and read it through to learn more.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #795431
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse