Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 6,041 total)

  • RE: The Cost of Database Downtime

    Jeff Moden - Friday, April 14, 2017 2:09 PM

    Steve Jones - SSC Editor - Friday, April 14,...

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

  • RE: Table size and indexes

    SQLRNNR - Friday, April 14, 2017 3:45 PM

    Eric M Russell - Friday, April 14, 2017 10:03 AM

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

  • RE: Table size and indexes

    Every table should have a primary key from the start; that's a given. Beyond that, I add indexes only when unit testing, QA, or post-deployment reveals the need for performance...

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

  • RE: The Cost of Database Downtime

    GeorgeCopeland - Friday, April 14, 2017 8:01 AM

    The system I work on has about 1000 online users, they all make about $30/hr,...

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

  • RE: The Cost of Database Downtime

    Steve Jones - SSC Editor - Friday, April 14, 2017 6:40 AM

    ...
    Does downtime cost Netflix? Sure,  there's some cost. They may lose...

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

  • RE: The Cost of Database Downtime

    ... There is a report for that database downtime averages $7900/minutedatabase downtime averages $7900/minute. My guess (if that's true), is that we have something other than a normal distribution....

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

  • RE: No PKs on fact tables

    Regarding this scenario, where a natural primary key would be composed of more than a handful of columns; in the past I've approached this by implementing a computed column on...

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

  • RE: The Value of Your Personal Data

    Sean Redmond - Thursday, April 13, 2017 1:29 AM

    Steve Jones - SSC Editor - Wednesday, April 12,...

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

  • RE: The Value of Your Personal Data

    If you want to know how much your personal data is worth, then ask your cell phone or internet service provider; they could give you the exact dollar amount they...

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

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Oracle has this special built-in table called DUAL containing (1) row and a single column called DUMMY with a value of 'X'. Because Oracle doesn't support using a SELECT statement...

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

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Eirikur Eiriksson - Wednesday, April 12, 2017 11:36 AM

    Eric M Russell - Wednesday, April 12, 2017 11:30...

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

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Microsoft should simply add a system tally table to SQL Server.

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

  • RE: Optimizing fact table for column store index

    I'm assuming we're talking about an OLAP or data warehouse type database here. Regarding the issue of where to contain the Event Description column, I can't say for certain unless...

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

  • RE: How do you define employee satisfaction?

    <sarcasm> C #8 Chip. Some employers are implanting their employees with tracking chips, which not only increases the employee's sense of safety and self worth but also let's them know...

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

  • RE: Does Speed Compromise Quality?

    I'm a lot more productive, and I can even code faster with fewer defects, when I have I have a clear set of specifications to work from. Lack of clarity...

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

Viewing 15 posts - 1,531 through 1,545 (of 6,041 total)