Forum Replies Created

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

  • 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. ...

    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

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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,...

    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...

    July 23, 2015 at 5:46 am

    #1814334

  • RE: Need login help to send files to

    If it's in a seperate domain, it may be easier using SSIS to do it, or output the file locally and use xp_ cmdshell to run a batch command to...

    July 21, 2015 at 10:15 am

    #1813905

  • RE: Synchronise table on remote server via update trigger failing

    Sean Lange (7/21/2015)

    andrew gothard (7/21/2015)

    Hi all,

    I have the following scenario.

    We have a database on...

    July 21, 2015 at 10:00 am

    #1813898

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