Viewing 15 posts - 2,791 through 2,805 (of 3,366 total)
Here is the link from one of the creators of relational calculus, and I also know Microsoft bought a company called Extera it make an aggregation engine for ETL sales...
May 11, 2007 at 8:18 am
(The ultimate ETL tool is a SELECT statement.)
ETL(extraction transformation and loading) is calculus and I just gave you two things you cannot do with a SELECT statement.
May 11, 2007 at 5:30 am
(The OLAP/ETL/DW/Mining pieces seem like they'll still be less heavily used and probably less heavily understood, but I'm open to being proven wrong.)
Steve,
Data Mining is what changed Amazon to a...
May 10, 2007 at 5:56 pm
(The ultimate ETL tool is a SELECT statement. The ultimate BI tool is Excel. Just about everything else is a waste of money.)
A SELECT statement is algebraically flawed so it...
May 10, 2007 at 5:30 pm
Actually no DTS is not as powerful but more flexible because you can deploy the runtime with your application. Here is the DTS site. Hope this helps.
May 9, 2007 at 7:39 am
These are free SSIS resources I am an automation expert in Asp.net be glad to walk you through for free it sure makes spread sheets disappear it is not complicated....
May 8, 2007 at 3:14 pm
The easy way to do it is to drop the current ones and use the Full text wizard and choose automatic change tracking because I think you are now doing...
May 8, 2007 at 1:32 pm
You can use the WITH CHANGE_TRACKING option for SQL Server to do it for you automatically or do what the consultant says because as I remember if the catalog is...
May 8, 2007 at 1:14 pm
In 7.0 it was only through triggers the built in one started in 2000 but without SET DEFAULT and SET NULL, the later were implemented in 2005. Cascade DELETE, Cascade...
May 8, 2007 at 7:22 am
Lynn has covered it ALTER ADD adds the column at the end of the table, if you want the new column in a specific location you use Enterprise Manager which...
May 7, 2007 at 10:03 am
Yes in 2005 Microsoft implemented a real ANSI SQL ALTER Table ADD Column, in 2000 you can only use Enterprise Manager for it but now you can do it with...
May 7, 2007 at 8:51 am
What you are getting is called character conversion you need to use Nvarchar with Arabic collation for the columns and tables you are using to store the Arabic text. I...
May 6, 2007 at 9:20 pm
deprecated meaning per Microsoft Encarta Dictionary.
(comput declare obsolescence of something: to state that a computational method or computer feature is superseded )
Encarta ® World English Dictionary © & (P) 1998-2005...
May 6, 2007 at 6:11 pm
Ralph Kimbal thinks because it is not standardized like the Algebra end, it can get convoluted, so a few good men and women who can think calculus wanted to create...
May 6, 2007 at 2:01 pm
Viewing 15 posts - 2,791 through 2,805 (of 3,366 total)