SA Developer .NET

NeverDie:

Thanks Gila.

I'm finding these days that Processing Power and memory available is not becoming an issue or bottleneck with performance anymore.

You're lucky. I've seen many systems where performance is still a big issue, due to large amounts of data, badly written code, poor indexes or all of the above. I don't mind. It gives me plentiful work that I enjoy.

You are quite right, the performance is around actually accessing the data. I've seen up to two thousand percent performance gains by just reworking the SQL to access the data better.

 I've seen queries go from a couple of hours to under a minute. I've heard of one go from 24 hours to 30 seconds with one minor change.