Forum Replies Created

Viewing 15 posts - 5,866 through 5,880 (of 6,041 total)

  • RE: Using a common seed generation for multiple tables.

    Randy Emerson (9/21/2010)


    I haven't found a solution yet. But here is why we are trying this solution. We have an address table which needs to be referenced from...

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

  • RE: Are There That Many GUIDs?

    GSquared (10/18/2010)


    SanDroid (10/12/2010)


    David Walker-278941 (10/12/2010)


    I originally didn't like GUIDs because I thought they used too much "space". They really don't. Disk space is cheap, and GUIDs are only...

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

  • RE: Are There That Many GUIDs?

    samalex (10/18/2010)


    ...

    It'd be nice if Microsoft would create a numeric data type that works as streamlined as a GUID but being more akin to an Identity field.

    Sam

    In Oracle...

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

  • RE: Are There That Many GUIDs?

    samalex (10/18/2010)


    Hope you guys don't mind me chiming in... We're working on a new system now, and my goal is to have a globally unique ID (whether INT or UNIQUEIDENTIFIER)...

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

  • RE: Risk Analysis

    Doug Lane (10/15/2010)


    Ben Moorhouse (10/15/2010)


    With disk space getting cheaper and cheaper, I'm considering doing some basic disaster recovery for home.

    Copying all music/photos etc onto a big disk and taking it...

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

  • RE: Risk Analysis

    Annette Ehrlich (10/15/2010)


    ...

    We are well prepared in the event that this office becomes a hole in the ground, I am glad to say, though I certainly hope that never happens.

    Regarding...

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

  • RE: Risk Analysis

    This is regarding how a company should go about quantifying the extent of investment required for disaster recovery. From my experience, the frequency of a company wide network outage tends...

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

  • RE: Learning Oracle

    nick.mcdermaid (10/14/2010)


    Here are my thoughts after going from many years SQL Server to an extended project in Oracle:

    I certainly found a lot of things in Oracle quite 'alien' to me...

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

  • RE: Learning Oracle

    PaulB-TheOneAndOnly (10/13/2010)


    Eric Russell 13013 (10/13/2010)


    On the other hand, SQL Server is newer ...

    Always remember SQL Server carries Sybase genes; don't look at SQL Server 4.0 as SQL Server date of...

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

  • RE: Learning Oracle

    harrifolfenced (10/13/2010)


    what are advantages of oracle over sql

    SQL Server is to Windows what Oracle is to Unix. Oracle has been around since the 70s or early 80s, and it carries...

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

  • RE: Are There That Many GUIDs?

    As for global uniqueness, I don't see why the column combination (center_id + cashregister_id + transaction_date) or database id + transaction identity id would not be as reliable, or more...

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

  • RE: Are There That Many GUIDs?

    TheSQLGuru (10/12/2010)


    <SmartA$$ ON>I LOVE it when clients use GUIDs in their database schemas - more tuning work for me!! 😀 <SmartA$$ OFF>

    Oh, come on! That's like a personal trainer saying:

    "I...

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

  • RE: Are There That Many GUIDs?

    The whole idea of encoding your server's network id and date/time stamp inside the primary key is practically a form of denormalization. For example, if you have a point of...

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

  • RE: Are There That Many GUIDs?

    What a weird coincidence; only a few nights ago, I had a dream that our precious reserve of globally unique identifiers was becomming depleted by poor database architecture design and...

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

  • RE: Downtime

    Four hours of downtime isn't bad for a disaster recovery, and assuming it was completed off peak hours, and the users were notified ahead of time, then it seems like...

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

Viewing 15 posts - 5,866 through 5,880 (of 6,041 total)