Sometimes formulas get complicated.  However, if you think you are going to use this over again somewhere in your application (and when have we not reused code), then I'm thinking...

Have you looked at the table(s) you are navigating thru and look at how they are indexed?  Chance are with upgrading from Access to SQL Server that there aren't any.

I would definitely update SQL Server directly.  T-SQL can be written in a way as to have only 1 user update a specific set of data at any given time. ...

I'm wondering if you even need the log of the "mirrored" DB. ? OR... for that matter, not simply truncating both logs on check point. Unless the datawarehouse has...

I used approach #3 on a smaller scale by creating fiscal year reporting tables of a much larger table. It allowed our OLAP/DSS users to query/report against this data...

I believe Unidata and Universe are later generations of the environment I got my start in, that being the PICK environment. I would think generating text files from the...

I'm thinking this may be a non-development DBA position. A pure backup/restore/configure/troubleshooting role without the fun of creating and building new things. The comments about the "junior" role...