Does the table the developer have primary key, foreign key and indexes? If the table has those, it will take a long time and a lot of resources. ...

Can you put a default value for 'UNKNOWN' in both tables ? Even foreign key can be null but it lost its purpose if the value is null. ...

How do you write your change script? Do you use Alter Database alter table?

I found out if you use alter table, it would take a long time to copy...

I want to know about the job, how do you control when to stop processing ?

This is just a thought of processing the dimension table automatically.

1. Procedure to...

The data structure, the primary key, the index are all belonged to the database side. Of course if you put in foreign key, trigger to enforce data integrity, this...

Recently I heard this from the news, a mother stood hours to wait to buy a concert ticket for her daughter, when the booth opened, all tickets were sold in...

Most companies like to put business logic in one layer, especially if they are writing web programs so they can have a thin client, and also this way it...

So they want to create a database with no business logic and the business logic will reside in the stored procedure, is that what your company want?

How are you going to know which table to update, is it based on a parameter?

CREATE PROCEDURE GenericProc

@TableName VARCHAR(100),

...

Each one has its own special structure. You have to talk to the company to find it out.

I used to work for a company that had a subsidiary in England, their normal vacation was 4 to 6 weeks. I remembered we had to send people there...

There are a lot of BI tools for example Hyperion (Oracle bought it a few months ago), Cognos, Business Objects (SAP was talking to buy it.) and many others.

Actually in May when I had pneumonia, I had to breathe using neublizers and I had to stay home because I was coughing so bad that I threw up all...

Thanks for all your support. I can't believe this thread creates so much response. I had problems with companies and managers before but this time I was particular...

The salary in Europe, Australia and New Zealand is very low, you sure you want to work there.