Forum Replies Created

Viewing 15 posts - 5,896 through 5,910 (of 6,041 total)

  • RE: NoSQL Is Not Everywhere

    David.Poole (9/21/2010)


    The premise of NoSQL is that for applications where data loss is not the end of the world then the overhead of an RDBMS is overkill. They work...

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

  • RE: Big Data and SQL

    I hope society never advances to the point where an understanding of relational set theory by the average person is required just to get by; most of our parents barely...

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

  • RE: Large Chunks of Data

    Whenever someone requests the creation of a new report, and the specifications don't seem clear or feasible (for example 50 columns fit upon an 11' landscape page), then I'll ask...

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

  • RE: easy sql data 2 excel?

    SKYBVI (9/17/2010)


    @ eric

    Ya, true , you have to give them a login and permission too.

    About the refresh page, there is a option in connection properties,

    refresh after __ minutes and also

    refresh...

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

  • RE: easy sql data 2 excel?

    SKYBVI (9/17/2010)


    Go to excel --> data

    data -->other sources

    -->sql server

    -->new connection

    write t sql script there

    execute, the excel would be filled with the result

    of the t sql specified..

    no use of...

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

  • RE: Best methods for investigating slow performance

    If users suddenly report that the database application is unresponsive, and you're looking for a first response script to tell you stuff like what connections are active, what processes are...

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

  • RE: Learning Oracle

    Most Oracle developers love cursors. I mean, it's so obvious they're in love. If you read an Oracle PL/SQL developer guide, it will be full of sappy love poetry dedicated...

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

  • RE: Large Chunks of Data

    The only practical way to report off of 5 million rows is to pull it into an OLAP cube, preferably on a different server or their local PC, and then...

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

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

    Jeff Moden (9/16/2010)


    I'm curious... Why do the folks that imposed this requirement think that it's a good idea to do?

    There are a narrow range of data modeling scenarios where a...

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

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

    Eric Russell 13013 (9/16/2010)


    A BigInt datatype has max value of 9,223,372,036,854,775,807, so it's large enough to allow several tables to reserve an identity seed of several billion. If you're planning...

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

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

    A BigInt datatype has max value of 9,223,372,036,854,775,807, so it's large enough to allow several tables to reserve an identity seed of several billion. If you're planning to impelment a...

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

  • RE: Social Engineering Dangers

    WayneS (9/15/2010)


    Eric Russell 13013 (9/15/2010)


    The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm...

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

  • RE: Social Engineering Dangers

    krowley (9/15/2010)


    Eric Russell 13013 (9/15/2010)


    The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm...

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

  • RE: Social Engineering Dangers

    The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm from the bank, they...

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

  • RE: Social Engineering Dangers

    Based on the cases I've read about, it seems that only a small pecentage of data breaches are the result of someone hacking the actual database server. From what I...

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

Viewing 15 posts - 5,896 through 5,910 (of 6,041 total)