Forum Replies Created

Viewing 15 posts - 4,231 through 4,245 (of 6,035 total)

  • RE: Hadoop and SQL Server

    Hommer (1/15/2015)


    Steve Jones - SSC Editor (1/15/2015)


    Eric M Russell (1/15/2015)


    My point is that the fundamental difference between relational databases versus Big Data NoSQL databases is actually not technical or even...

  • RE: Hadoop and SQL Server

    FunkyDexter (1/15/2015)


    Run Hadoop on a single node...

    True but you might as well say "Chop a horses legs off and all you've got is pedigree chum." The whole point of...

  • RE: Hadoop and SQL Server

    patrickmcginnis59 10839 (1/15/2015)


    Eric M Russell (1/15/2015)


    Robert.Sterbal (1/14/2015)


    I think some of those geeks would also say that they want to supplant Microsoft licensing from their data.

    Microsoft handles the needs of...

  • RE: Hadoop and SQL Server

    Robert.Sterbal (1/14/2015)


    I think some of those geeks would also say that they want to supplant Microsoft licensing from their data.

    Microsoft handles the needs of small numbers (less than 100)...

  • RE: Hadoop and SQL Server

    Another thing about Hadoop is that the files contain data in raw unstructured format (perhaps not necessarily but at least typically) and the MapReduce process parses and performs complex computing...

  • RE: Hadoop and SQL Server

    Steve Jones - SSC Editor (1/14/2015)


    Eric M Russell (1/14/2015)


    Can you image a ColumnStore table federated across multiple nodes?

    Now that's kick ***!

    That would be something, though I'd also like...

  • RE: Hadoop and SQL Server

    Hadoop is a primitive database management system in terms of indexing, query plans, and usability of it's query language(s). It's a major player only because of it's ability to scale...

  • RE: Testing

    In my universe, the root of most UAT or production change requests isn't coding mistakes or oversights on the part of the developer, but rather that the functional requirements don't...

  • RE: group by part of string

    x 45204 (1/14/2015)


    Thanks guys - it dont solve the issue i was having 100%, as the messages I needed to group together simply was too complex and no real pattern...

  • RE: "poor man's replication" ETL process design

    TheSQLGuru (1/12/2015)


    So you believe that adding a timestamp and non-clustered index to a table is more likely to break production than adding a trigger than inserts into an audit table?...

  • RE: "poor man's replication" ETL process design

    If you had access to the transaction logs, then you could do log shipping replication. If you had an actual login account, then you could leverage SSIS.

    Having to operate...

  • RE: Data Lakes

    Steve Jones - SSC Editor (1/12/2015)


    It is similar to a database, but the scale of data in most companies (overall), exceeds what a single RDBMS can handle. I'm not sure...

  • RE: "poor man's replication" ETL process design

    TheSQLGuru (1/12/2015)


    Eric M Russell (1/12/2015)


    bantrim (1/12/2015)


    I'm going to have to show my colleague yours and Kevin's posts since, to her, triggers are four-letter-words. We've gone back and forth since...

  • RE: "poor man's replication" ETL process design

    bantrim (1/12/2015)


    I'm going to have to show my colleague yours and Kevin's posts since, to her, triggers are four-letter-words. We've gone back and forth since we first met over...

  • RE: "poor man's replication" ETL process design

    bantrim (1/12/2015)


    Eric M Russell (1/12/2015)


    Using hash or checksum techniques to detect modifications to bulk numbers of records is inefficient (it has to read and hash all columns) and not reliable...

Viewing 15 posts - 4,231 through 4,245 (of 6,035 total)