I think one thing all of this discussion points out is the importance of proper validation of data either at the application level or the database update level. or probably both...

crmitchell (12/23/2016)

---

Until that one occasion where it does matter. As Murphy and Sod will cheerfully...

gfish@teamnorthwoods.com (12/21/2016)

---

Let me suggest a much simpler way of avoiding the CPU spike caused by running multiple jobs at once. Simply combine them into one job, with the contents of...

skeleton567 (12/20/2016)

---

Igor Micev (12/20/2016)

---

skeleton567 (12/19/2016)

---

Two things are going to cause CPU spikes by scheduled jobs:

1. Poor design that causes a requirement that a job be run too frequently.

2. ...

Igor Micev (12/20/2016)

---

skeleton567 (12/19/2016)

---

Two things are going to cause CPU spikes by scheduled jobs:

1. Poor design that causes a requirement that a job be run too frequently.

2. Delusions...

Two things are going to cause CPU spikes by scheduled jobs:

1. Poor design that causes a requirement that a job be run too frequently.

2. Delusions that the function...

Wingenious (12/7/2016)

---

If we were all deeply pessimistic about redeveloping software then we might still be using VisiCalc.

Sure, redeveloping software involves costs and risks, but so does running a business on...

Wingenious (12/6/2016)

---

I would run out of fingers if I tried to count the number of times I have inherited a database mess with a new job. The new employer always...

Iwas Bornready (12/6/2016)

---

I worked with a programmer once who would run across some code that he thought should be optimized, written better. So he would modify the code. Half the...

TD-238967 (12/6/2016)

---

You should see the "forest" instead of the "tree". Think first, code later then you can have the best solution for your project. There so many best...

Brian J. Parker (12/6/2016)

---

There are, as you and several commenters note, a lot of factors; I wouldn't say that there was a universal best approach.

Generally, what I've done is introduce...

dhsweg (12/6/2016)

---

I generally opt for the 'scrap and start over' approach. Building on a poor foundation is not a good practice, and if I must dig all the way...

Early in my career I found myself in a situation, as a new IT manager for a company that had already hired a consulting company to begin design of their...