I think something that is often missed is monitoring - people set up lots of lovely processes and systems, backup plans, etc.etc. - but then they (or management, or management...

Just an update from my earlier email and our friends with the count(*)'s 😀

The developers `moved some tables` and `made some tweaks`, gave us an update 🙂

15 minute process now...

On the backend business logic front, ive been steadily increasing how much I put directly in the db rather than in the front end for some time now.

My main db...

Superb, many thanks for that 😀

Martin (learnt another new thing today)

There is one way to get around the problem of all the many many variants of bounce backs and how to process....

....don't worry about it. Anything that comes in to...

Incase anyone is interested, I thought id further the DIY thread 🙂

Looking around at various solutions, for those interested in doing it by hand, there are a few methods you...

Very interesting im going to investigate too 🙂

Many thanks

martin

Actually theres another route that ive discovered, which seems the proper way to do it and doesnt seem that complex.

Called `Event sinks`, and are there for just such occasion!

A bit...

Hi there Wayne!

Unfortunatly I didnt get to speak with their developer directly, so I indirectly passed on suggestions such as `checking for table in sysobjects` and the ever helpful `why...

Lovely example of a coding `performance issue` we found just before christmas...

A collegue here overseas a system with a process they were running that was incredibly slow. (External product we...

I learnt something new today 🙂

thanks!

much clearer

thanks guys 🙂

martin!

many thanks guys, I will read and digest!

martin 🙂

Ill add an extra point 🙂

#Get to know your general IT support structure you don't control

Over the years ive been databasing, ive got to know how our IT support works...

I personally find sp's take longer to develop, some things are far trickier/long winded to code compaired to in external alternatives (isnt that one reason why they introduced the CLR...