I use surrogate key for all my dimension table.

As for updating the existing data and inserting new data, it is better to understand how the ODS works.  Do they update...

These days it is very hard to find a good place to work. Most companies are under a lot of pressure of the stock market, in order to save money,...

If your company has to send data to multiple clients, then I would use XML, so it becomes the standard and easy to change.

Our company gets data from other sources,...

You can try to use return value to let sp1 know there is a fatal error in sp2.

Create procedure sp2 AS

IF OK

RETURN 1

ELSE

RETURN 2 

In sp1

Declare @ReturnValue INT

EXEC @ReturnValue = sp2

IF...

Sameer

I know you hate my guts.  If posting comment to trash me makes you feel good, then you are very welcomed.

I use SQLDBCompare from BestSoftTool and I like it a lot. 

I agreed that we all need to improve our SQL skill or technical skill all the time.  I am not saying I am the best SQL developer.  As a matter...

I am sorry if my post was a bit strong. I just put down something I experienced when I worked at that company.  I did not 'attack' the company, I just...

One more, if you go the web site and type the number 06000162, it is a Data Architect job.  That is even worse.  That department is notorious.  No other...

Facts about Citibank in NY (from an ex-employee) :

1.  90% of the SQL Developers in that compnay do not know how to spell 'SQL Sever'.  They go to the DBA for...

I found this on Microsoft web site.  I don't know if it has something to do with my failure of installing reporting service.  I am trying to install SQL Server...

The problem I got was

'Unable to read the Server Registry, or you are not a member of the OLAP Administrators Group".

I have checked the OLAP Admin group and I...

Semeer Raval

You disagreed with me because of what I wrote in this thread or just because of what I wrote in other threads.

I think I built up an army of...

I am a SQL developer using Oracle and SQL Server.   I did some data warehouse work before.  I do very little C#.

Tatsu - "Hey, all this discussion made me realize something. If the management stinks in the company you work for and they are not doing anything to help the company then it's...