I have done the same Jack - triggers can bee good for auditing because I usually want them to be part of the original transaction and like them to be...

Specifying the use of NOLOCK on every query is a mistake made by a lot of people that simply do not understand what the problems of dirty reads can be.

It...

In addition, if your "other" queries only needed the two specified columns, creating a "covering index" - which is an index that completely encompases the fields your query will need...

Where are you putting if the "Run Balances"? You are calculating this in a derived column? A derived column executes once per row in the data flow and...

That's probably a reasonably good starting position - "How can I accomplish this without a trigger?". I would put this right along with "How can I accomplish this without...

A SQL 2005 license is required to upgrade from SQL 2000 to SQL 2005. There are some upgrade paths - talk to your software vendor.

Install the Oracle client - I think the 8.4 client and newer includes a complete OLEDB provider. They are not 100% OLEDB compliant (even the 10g client is not).

You...

You will probably not be able to copy a 40gb file over your WAN. For initialization, I would suggest you do a backup and FedEx it. While it...

Ok, so the connection pool error is related to having used up all of the available connections in the pool. Yes, this is caused by not closing connections in...

GGKK - you have most likely over-partitioned your cube. You should look at the project REAL documentation for some tips about partitioning. With only 5 million rows per...

They are bosses because they don't know how to do the work...

Create another table to keep track of the next "CustomerID". Or, if you have a customer table and...

You should not have "too many" open connections from connection pooling. If you have a central application server that connects to the database (which I assume you have because...

Bummer - no replies yet.

I'll reply myself because I think I found something that is going to work. If anyone sees an issue, please let me know.

At first, I...

If you have a measure that is the number of minutes, the sum of this measure by date (assuming you have a date dimension) should be the number of hours...

Hey - don't attack me, I said it was a bad idea, I just figured I would give an example in which it could actually help something.

As far as the...