The correlated queries would be more exception than the rule - you're correct in that most situations it would be on the entity tables, or between them.  The idea with...

I appreciate the input, guys...

...Sergiy, I think we're talking about two very different applications.  I've done one before similar to yours and had great results with that kind of design. ...

Thanks for the reply - perhaps I can clarify something - the list of entity tables (Apps, People, HW) already exist as part of a data warehouse application.  Are you...

This story is from a friend of mine; wish I could have been there to witness it.

The tech support team recently hired a new hotshot tech.  One day this tech...

And, if folks refuse to install the WGA and don't patch their machines, you have a whole new set of vulnerable machines in the world ripe for the picking, which...

Ok, now here's a new twist - I played around with it some more, and to save time I didn't preprocess any aggregations - and the numbers WORKED.  Run the...

it's joined by a key.  and everything is multiplied by exactly 5, it's not a sum.

the annoying part is that I ran into this problem a month ago, solved it,...

Thanks folks - I ended up going with RAISERROR (duh....forgot about it) but I love the select 1/0 answer!!  Very clever.

Curious about the CREATE ASSEMBLY command - does it just create a pointer, or does it actually compile the code into the SQL server?  I'm trying to imagine the scenario...

And it's not just schema changes; this also applies to any code (stored procs, functions etc) that would also get reverted to production every night.  If there was a way...

3.5GB RAM.  I'm really not too worried about it, as this is a dev server.

I did end up doing multiple ports last night, seems to work fine.  I put together a .reg file so folks here can automatically add the 3 instances' aliases to...

just wondering...what if you changed the collation of model?  Would that have any effect (for new databases)?

This would be an in-house position.  Thanks for asking.

Here is the problem I am running into, in 2005 - the way that we have implemented SOX regulations is to segregate operational and development duties - thus, as the...