Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

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



Group: Administrators
Last Login: Yesterday @ 9:28 PM
Points: 34,372, Visits: 18,590
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