Forum Replies Created

Viewing 15 posts - 196 through 210 (of 631 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/18/2015)

    Lynn Pettis (9/18/2015)

    SQLRNNR (9/18/2015)

    Jack Corbett (9/18/2015)

    Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 21, 2015 at 10:46 am

    #1828157

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/18/2015)

    Jack Corbett (9/18/2015)

    Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 21, 2015 at 7:11 am

    #1828069

  • RE: Lockdown All Databases Except One

    GilaMonster (9/15/2015)

    Or, just spin up a VM and give the developer a copy of the database on a VM that contains nothing else.

    I couldn't agree more with Gail there. ...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 15, 2015 at 4:47 am

    #1826687

  • RE: Security - Server Roles

    I believe it means it's a built in role the permissions of which you can't modify

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 10, 2015 at 4:28 am

    #1825627

  • RE: Remove String from column Post Code Field

    BWFC (9/8/2015)

    A correctly formed postcode can be 7 or 8 characters - eg SW1A 4WW so change RIGHT(PostalCode, 7) to RIGHT(PostalCode, 8) and LTRIM the result

    Postcodes can be 6,7 or...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 9, 2015 at 3:16 am

    #1825337

  • RE: Remove String from column Post Code Field

    Lowell (9/8/2015)

    can you make an assumption based on the length? your example using charindex of the left parenthesis doesn't match your sample you posted.

    ;WITH MyCTE([PostalCode])

    AS

    (

    SELECT 'Derbyshire S42 5BX' UNION ALL

    SELECT...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    September 8, 2015 at 7:05 am

    #1825105

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/13/2015)

    Sean Lange (8/13/2015)

    Every table name and every column name are exactly 6 UPPER case letters.

    I feel your pain. Baan's tables were named using a multi-part naming convention...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    August 25, 2015 at 8:33 am

    #1822212

  • RE: Nope to NoOps, No way to NoDBA

    david.andrew 41944 (8/16/2015)

    Phil great story.

    I had a similar thing here

    I was asked to do a Mysql Load balanced cluster.

    Not being something I'd done before, or this department had done I...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    August 17, 2015 at 7:20 am

    #1820425

  • RE: Nope to NoOps, No way to NoDBA

    pparsons (8/15/2015)

    And how about we assign GUIDs for all primary keys? ... oh ... and clustered too ... No one listened to this veteran, and while we're at it...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    August 17, 2015 at 7:15 am

    #1820423

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/10/2015)

    Steve Jones - SSC Editor (8/10/2015)

    Query query, sql sql, should we debate tomatoes and potatoes as well?

    How about "daytah" vs. "dahtah"?

    I thought Patrick Steward sorted that...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    August 11, 2015 at 9:50 am

    #1819035

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/5/2015)

    Sean Lange (8/5/2015)

    GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against the wall...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    August 11, 2015 at 6:41 am

    #1818898

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/30/2015)

    Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve performance issues?

    Work...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    July 31, 2015 at 6:03 am

    #1816400

  • RE: non trusted constraints vs performance

    GilaMonster (7/27/2015)

    For whatever reason (probably bad data), they've just created them WITH NOCHECK. It's not going to cause performance problems.

    Never? What if one of the untrusted constraints is, for...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    July 27, 2015 at 3:16 am

    #1815058

  • RE: Are the posted questions getting worse?

    I see there's an article by JC on the main page today, isn't he barred? If I click on it will I not actually be able to see it,...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    July 24, 2015 at 5:31 am

    #1814698

  • RE: Are the posted questions getting worse?

    BWFC (7/22/2015)

    Aargh!!

    'Why didn't this appear on your report? It's wrong. There's been an incident and you've made us look bad in front of government.' - The Business

    <investigates>

    'It's not...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

    July 23, 2015 at 5:46 am

    #1814334

Viewing 15 posts - 196 through 210 (of 631 total)