Viewing 15 posts - 1 through 15 (of 34 total)
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...
August 23, 2007 at 8:20 am
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,...
July 2, 2007 at 5:41 pm
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,...
February 23, 2007 at 5:32 am
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...
February 2, 2006 at 7:01 pm
Sameer
I know you hate my guts. If posting comment to trash me makes you feel good, then you are very welcomed.
January 18, 2006 at 9:34 am
I use SQLDBCompare from BestSoftTool and I like it a lot.
January 17, 2006 at 1:20 pm
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...
January 17, 2006 at 10:17 am
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...
January 17, 2006 at 9:40 am
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...
January 16, 2006 at 3:42 pm
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...
January 16, 2006 at 3:24 pm
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...
January 12, 2006 at 6:35 am
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...
January 6, 2006 at 12:45 pm
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...
November 28, 2005 at 8:16 am
I am a SQL developer using Oracle and SQL Server. I did some data warehouse work before. I do very little C#.
November 18, 2005 at 2:57 pm
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...
October 27, 2005 at 6:33 am
Viewing 15 posts - 1 through 15 (of 34 total)