Forum Replies Created

Viewing 15 posts - 3,946 through 3,960 (of 6,041 total)

  • RE: What is a "set-based loop?"

    Jeff Moden (4/26/2015)


    ...

    The other type is probably not what most people would expect. R. Barry Young coined the phrase for these "set based loops" (which is exactly what I...

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

  • RE: Microsoft Exercise

    I've heard that public shaming works.

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

  • RE: Your Role Is Changing

    stevenp333 (4/27/2015)


    I wonder whether any companies use the DevOps idea to draw developers into a support role and then shut the gates behind them?

    It might be that many large established...

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

  • RE: Embrace Stored Procedures

    Steve JP (4/24/2015)


    There is a senior who wants to replace all the inline sql statements with sprocs. Well fine, the application will stop looping through 1000 inline statements and now...

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

  • RE: Your Role Is Changing

    If users demand access to the 'SA' account, then give it to them.

    But first get rid of the default 'SA' and then create a new one having only the permissions...

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

  • RE: Your Role Is Changing

    If a database architect, IT support, executive, or BI developer needs eleveated permissions to troubleshoot performance issues or run ah-hoc queries in production, you can setup something like a power...

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

  • RE: Your Role Is Changing

    stakes (4/23/2015)


    And did you ask what they want to be able to do?

    I think every DBA should sit down with the application development team at least once a year and...

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

  • RE: Your Role Is Changing

    For many of us, the role hasn't changed, it's just been defined using a new acronym, which makes it a lot easier if someone asked what we do.

    DevOps, I...

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

  • RE: Would a Duress Password be a Good Idea?

    Charles Kincaid (4/22/2015)


    Eric:

    In Japan would that be floor 4, and for the same reason?

    Jeff:

    Are you older than me? I guess that it could happen.

    Also don't mess with disabled folks....

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

  • RE: Would a Duress Password be a Good Idea?

    lptech (4/22/2015)


    Simply not allowing access would put the person using the duress password at risk of serious injury or death. The duress code would have to lock down the building,...

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

  • RE: What is the Formula to estimate\forecast space for non-clustered index on a table

    ScottPletcher (4/22/2015)


    Eric M Russell (4/22/2015)


    ScottPletcher (4/22/2015)


    With an existing table, you already know what the length of the columns will be, whether varchar or not. The formula provides you with...

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

  • RE: What is the Formula to estimate\forecast space for non-clustered index on a table

    ScottPletcher (4/22/2015)


    With an existing table, you already know what the length of the columns will be, whether varchar or not. The formula provides you with the additional overhead SQL...

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

  • RE: Would a Duress Password be a Good Idea?

    lptech (4/22/2015)


    In the Charlie Hebdo attack, the terrorists forced an employee at gunpoint to swipe her card to get into the building. So a duress password on top of the...

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

  • RE: What is the Formula to estimate\forecast space for non-clustered index on a table

    LearnSQL!!! (4/22/2015)


    Hello,

    What is the best way to forecast\estimate space for non-clustered index on a table?

    Example :

    Table name : Test123

    Row : 170000000

    Reserved : 18000000 KB

    Data : 70000000 KB

    Index: 40000000...

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

  • RE: Would a Duress Password be a Good Idea?

    Really, Google itself is just a massive honeypot used by marketing dicks to brand us and retail our browsing habits.

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

Viewing 15 posts - 3,946 through 3,960 (of 6,041 total)