If you're building the app, I'd write the calc into a stored proc and have the insert/update and the calc/update occur at the same time.

Are reports retrieving the values?...

How are you importing the data? Many methods allow you to not fail on 1 error. Or you can import into a staging table and then clean the data.

PKs...

Actually I like this. It tells me who not to go to for a job. Kind of recruiting Darwinism

It creates more administration and complicates disaster recovery, but it can help. However it's not necessarily a big performance boost:

http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

Search naming standards on this site and you'll find a few references as well for helping with that.

http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

http://www.sqlservercentral.com/columnists/sjones/serverconsolidation.asp

there are good reasons to go either way. You use an interest statement and a small app to load the stream makes the most sense.

The best way I know of is to do this in batches. Delete xx records, backup the T-log, repeat. This way you can prevent the log from growing too much....

Please type in the error message and send any other information we might be able to use.

Scott,

No mourning the 'Wings?

I'll be doing some fencing in addition to the scooping. At least if I can get the telephone people to mark the underground wires.

MySQL scales and I actually like the architecture. Different storage engines can be swapped in. I'd never run without the transaction and PK/FK checks, but maybe you'd want them. What...

Whoops, sorry. As much as I'd like to use B in a few cases, it's really C. I moved the answers and corrected points.

Girish, that is not the case in logical operations. With an AND, only one operand is required to be false to give false. So if one side is false, it...

Miles,

Great comments and the risk issue is a big one that people forget about. I have some friends that are whizzes with open source, especially the LAMP stack and they'd...