Steve Jones - SSC Editor (10/11/2010)

---

Sorry for the delay.

Not that I know of. We have it set to default to the last setting you used for the previous post, so...

You are joining the tables, so a single row in the ProjectSupporter is being joined to all 23 rows in the StandardSupporter table, giving you 23 * ProjectUtilization number.

You need...

I believe the stored procedure on this link will do a good job for your requirements. Tara Kizer has been improving and enhancing this script for several years, so...

DEC Rdb was introduced with clustering similar to RAC in 1984. My assumption is that Oracle acquired a lot of the technology for RAC when they bought Rdb from...

You are the one saying I was "Very incorrect". If you can't backup your statement, I guess there...

So, you are saying Honda engineers would let...

Any response?

I think the analogy is completely flawed.

If you want a true analogy, it would be between the process used to design and develop the engines and the software development process....

No.

In a typical development the schema design is done by a database guy who is obsessed with micro-optimization of individual tables. He fusses over minimizing table size and deciding things...

Why not just make it so that all cash flows are at the pool level, and create pools with a single investor where the cash flow has to be at...

GilaMonster (10/5/2010)

---

And just when I thought the project I'm on couldn't get any worse..

We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...

getoffmyfoot (10/5/2010)

---

dynamic sql is also more susceptible to sql injection. you might find it cleaner to have 2 queries with different formatted where clauses and an if statement that chooses...

You could create a database snapshot for users to report from, and continue to apply logs to the database.

Users would only be disconnected when you recreate the snapshot. Users...

One thing no one has really mentioned is that you become less effective past a certain number of hours, so for the additional 5 hours a week, you may really...