Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 6,041 total)

  • RE: What's the difference between the Data Reconciliation layer and ETL processes?

    Data Reconciliation can involve things like identifying the uniqueness, completeness, and validity of records. That logic may not be part of the injest, but rather a process that analyzes and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Data Mining book

    I read the 2nd edition of this book several years back. It's not about how to use BI tools at all, but rather more about how to apply data mining...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: When we talk about fragmentation, is it "Index Fragmentation" always ?

    As a result of updates, heap (nonclustered) tables can accumulate a type of fragmentation called "Forwarded Records". If the updated row incrases in length and SQL Server can't fit it...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Treat the Database like Code

    Regarding the issue of how to implement a rollback when deploying DDL/DML scripts, I'd prefer to deploy major changes (altering or bulk updating large tables) at an off hour with...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: SQL Knowledge Transfer for new project

    mohan.bndr (3/29/2012)


    Hi,

    I am going to handle new project in my org., before that i need to know technlogies,versions,application softwares and databases etc. that they are using. So I require help...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Raw Data

    Google the following:

    site:*gov data publications

    For example:

    http://www.census.gov

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Dallas Tornados

    Seeing the shattered remains of all these businesses in the wake of a tornado or hurricane is also a reminder of the importance of off-site backups. Insurance will cover the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Treat the Database like Code

    Grant Fritchey (4/5/2012)


    No online ones coming up. SQL Saturday in Atlanta a week from Saturday... Um... Rally in Dallas, SQL Saturday in Rochester. Those are the best opportunities I have...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Rollback Update Statement

    If you can implement this requirement as a table check constraint, then that would perhaps be the best solution, because it would involve no programming work arounds. For example, let's...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Treat the Database like Code

    I use TFS, but up until about three years ago, I was still using Visual Source Safe 6.0. It was good enough for versioned source control, which is why it...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Catching the culprit!!

    It's a heck of a lot earier and cleaner to install guard rails around the edge of a bridge to prevent people from leaping, than it is to install a...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Treat the Database like Code

    I maintain DDL scripts for each object in the database. I don't maintain a series of incremental change scripts, but rather there is one script per object. Typically, the script...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Catching the culprit!!

    S_Kumar_S (4/5/2012)


    A bad update can be anything that makes the data which it should not be. e.g. someone running update statement without where clause or someone updating incorrect values e.g....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Catching the culprit!!

    S_Kumar_S (4/3/2012)


    We have a table which is used by many pages on our website.So it's an important table.

    Now during development( I am talking about development environment here, no production),...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Data Mining Data Warehouse For Beginners

    n00bDBA (4/3/2012)


    Thanks Eric,

    I just don't want to start asking around and saying im planning on doing this super great thing.. then fail horribly at it! I work in a...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 5,191 through 5,205 (of 6,041 total)