I thought you are talking about me...... Database developer during the day, the maid of the my family when I am not working at my office - that is the...

If you are in China doing business, every Chinese business man would say 'absolutely YES'. That does not mean they would try, that means they would use anyway to...

Some companies require certificate MCDBA to apply for a DBA job. However the best DBAs I had worked with; none of them had a cert. Those companies missed...

Can you give more info of what you want to do? When you said someone gave you a number and you wanted to know which records would sum up...

That is the problem. Nowadays you don't know who to trust. I thought I could trust my old manager who became my new director. He liked my work and thought...

After all these years, I am embarrassed to say that I don't write too much comments in my procedures.

I try not to use cursor, probably because when I first learned...

I agree with you. That is the reason why I visit this website so often so I can learn something, or someone can help me to solve a problem...

I think most managers want to use 'me' or developers to show how efficient the team is. I remembered one time in previous company, there were two managers in our...

It is recommended that the fact table should not have more than 8 dimensions. Of course you can have more than that. Actually if your fact table has 8...

BTW, why varchar(1020) ? How did he pick this number?

I agreed at this point, if it is working, don't do anything. Once you start making changes, you basically have...

Next time when you are looking for a consultant, make sure that person knows what a data warehouse is ? Also most companies have this mistake, including my...

It seems I always encounter this kind of manager. I have a new manager in June, he is stubborn and arrogant, do it my way or no way. He wanted...

We used window authentication, so there is no need to put user id and password in the procedure.

Thanks. After all these years I think I still do not know how to play the politics. That is why I always get in trouble.

It does not...

His reason is once he received the data, he just needs to start the job to insert into one table, then the trigger will automatically update or insert into other...