Viewing 15 posts - 331 through 345 (of 1,062 total)
If you ever worked with Oracle products, then you would appreciate Microsoft products.
Years ago, Oracle already had a data warehouse product called Oracle Express, now they called it Oracle...
February 18, 2008 at 9:43 am
First you have to link the two servers together. Then I create a DTS package on the SQL Server 2000 to extract data from 2005 and load into the...
February 18, 2008 at 9:29 am
A lot of senior developers move to management, it seems it is a good career move just liked you said in the article. However not everyone is manager material,...
February 18, 2008 at 8:17 am
If the table in different database, you need to put in databasename.owner.tablename in the query. If the database in different server, you need to create a link server ,...
February 18, 2008 at 7:45 am
Why can't you put contact under Supplier and Wholesaler ?
CREATE TABLE Contact (contactID INT NOT NULL,
...
February 16, 2008 at 2:25 pm
I always use star schema.
Are you using analysis service to create the cube? If you do, then you don't have to worry about the fact table. ...
February 16, 2008 at 1:59 pm
Maybe you should take care of each customer table first, the dataset is smaller and easier to handle.
To find customer with duplicate record
SELECT FirstName, LastName, Email, COUNT(*)
FROM Customer
GROUP BY FirstName,...
February 15, 2008 at 4:58 pm
How do you define a customer is duplicate in the system, the same customer number, the name, the same address? So are you going to put an index in...
February 15, 2008 at 7:54 am
It always takes a long time when you load the data into the data warehouse table the first time.
Anyway where are the source of the data coming from?...
February 14, 2008 at 2:40 pm
I had worked for two software companies and the hours were decent.
It all depended on the company and the management.
I worked for big company (fortunate 500...
February 14, 2008 at 1:38 pm
Most companies think building a data warehouse is liked implementing another database. It is a totally different.
(a) Importing all data from the various transaction databases into the staging area
What...
February 14, 2008 at 9:48 am
Great article.
I had used a lot of other development tools - waterfall method, iterative method, extreme programming (it sucked), CMM (capability mature model). So Agile is another one....
February 14, 2008 at 9:14 am
I assume you just want the date in the table.
CREATE TABLE YourDate (DateCol DATETIME)
DECLARE @StartDate DATETIME,
...
February 13, 2008 at 2:44 pm
Don't worry Steve, I don't mind to answer the same question again! 🙂 Actually the question looked familiar but I did not remember the answer.:blush:
February 12, 2008 at 4:48 pm
How many index do you have right now? You can only have one cluster index in one table, are you sure you do not have one cluster index now?...
February 12, 2008 at 12:01 pm
Viewing 15 posts - 331 through 345 (of 1,062 total)