Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 3,366 total)

  • RE: Drinking the Kool-Aid

    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...

  • RE: Drinking the Kool-Aid

    (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.

  • RE: Drinking the Kool-Aid

    (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...

  • RE: Drinking the Kool-Aid

    (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...

  • RE: DTS Specific Courses

    No problem I am glad I could help. 

     

  • RE: DTS Specific Courses

    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.

    http://www.sqldts.com/

  • RE: DTS Specific Courses

    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....

  • RE: Understanding Incrementals with Full-Text Indexes

    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...

  • RE: Understanding Incrementals with Full-Text Indexes

    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...

  • RE: cascading delete..what is it?

    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...

  • RE: Addding a new column to table in use...

    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...

  • RE: Addding a new column to table in use...

    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...

  • RE: Arabic fields returning "######" or "????????"

    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...

  • RE: DBCC DBREINDEX, scan density not improved

     

     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...

  • RE: The Coffee and Donut War

    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...

Viewing 15 posts - 2,791 through 2,805 (of 3,366 total)