I find it interesting that you would say a tivo is stable, isn't that like saying a toaster is stable?  I mean it is a single function device that you...

Some business logic can ber *very* complex and therefore can threaten the databases ability to scale. What we may think is easy today may become very complex 1 or 2...

I can only speak from experience. I was with my last company for four+ years. I worked on the enterprise architecture as the company grew from 1 million to 20...

Interesting topic.

Of course referential integrity belongs at the database, the database has to be responsible for ensuring the data is as valid as posisble.

Scenario: I put my business logic in...

Yes, dynamic SQL is useful, I just dont like it.  Sometimes it is a matter of table design that can remove the need to query using a dynamic table name...

It's actually quite simple.

inside a string two single quotes next to each other embeds on quote in the string, therefore:

'It''s going to rain on Michael''s head today'

would create the following...

I would prefer ID, Code, Description where ID is identity int and Code is unique.  Not sure I care if description is unique although I can see that as a...

Ok, I am sorry - not really - but this is design madness. 

Seperate tables for...

I would also recommend UNION ALL

Of course I would prefer to see a more normalized table

I prefer option 1 with the following suggestions

give each machine an ID

in your master database tables include the following

machineid column

identity column

update_date

that allows you to know immediately if you have imported...

If you want soemthing like rownum, ad an identity column.

If you are looking for a free web based solution then click this

http://groups.msn.com/OLAPServicesDevelopersForum/web.msnw?action=get_message&mview=&ID_Message=45

you will have to join the group if I remember correctly.  it is a very helpful and...

Glad to be of assistance!

I just love SQL, now Microsoft, where is that natural join syntax I've been waiting for, I'd like to save some typing!

And wouldn't everyone just love...

Ok, I must ask, why would you ever query on ID and Dept if ID is unique?  If I am selecting a record and I use a where with a...

You need to be really careful with this for a couple of reasons, first, a #temp table is stored in the tempdb which can cause tempdb bloat, second, if the...