Unfortunately, I firmly believe from what I saw during my years in IT is that 'big data' is often the result of system design that is incomplete and lacking in foresight. ...

As with any business process, implementing changes can be under-managed or over-managed.  Several years before I left a DBA position I discovered that a particular set of about a dozen self-requested...

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