Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 9,707 total)

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/19/2015)


    jasona.work (11/19/2015)


    I was going to post this over in Steve's call for Good Basic T-SQL Exercises but decided not to pollute the topic with fluff...

    So I'm posting it...

  • RE: windows user not login to SQL?

    Sounds like an orphaned user to me. Check the database level security and the server level security in the GUI. Remove the database level security, then go to the server...

  • RE: Help with persmissions and server roles

    Is this in production or a non-prod environment?

    If production, you might want to have a discussion with your boss about the issues of giving DB create permissions in a production...

  • RE: Strange Replication issue - trying to find root cause

    You may never find an issue to this answer. Sometimes Replication just stops.

    The first places to check, though, would be the error logs (for any weird warnings or errors) and...

  • RE: Are the posted questions getting worse?

    Sean Lange (11/18/2015)


    Jack Corbett (11/18/2015)


    Phil Parkin (11/18/2015)


    Jack Corbett (11/18/2015)


    Remember, it is not about winning or losing because everyone is a winner if they try their best...

  • RE: Both principal and mirror down

    When the witness does not exist and the primary goes down, I believe mirroring will be broken and you have to manually make the mirror DB the primary.

    I know when...

  • RE: NOT IN versus IN

    May I also point out that NOT IN vs IN is a different matter than NOT LIKE and LIKE?

    NOT IN and IN only consider whole value comparisons where NOT LIKE...

  • RE: Inserting into Temp tables

    Or, instead of dropping temp2, change the second "INTO temp2" to an "INSERT INTO temp2 (column list)" like you did with temp_p.

  • RE: Are the posted questions getting worse?

    robert.sterbal 56890 (11/18/2015)


    Luis Cazares (11/18/2015)


    Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize them, I'm not sure if search engines would care,...

  • RE: Copy of 1 TB prod database

    GilaMonster (11/18/2015)


    Brandie Tarvin (11/18/2015)


    tripleAxe (11/18/2015)


    Striping the backup to multiple backup files can help you reduce the backup/restore time.

    In my experience, I have seen no difference between restoring striped files...

  • RE: Performance impact of self-referencing Linked Server

    Jeff Moden (11/17/2015)


    As a bit of a side bar, I strongly recommend NOT using 3 and 4 part naming anywhere except within a synonym or passthrough view. I...

  • RE: 150 GB Backup (compressed) taking over 1 day

    jbrandenburg (11/17/2015)


    How is this configuration option completed? What is the impact of doing so?

    Which configuration option are you talking about?

    Have you gotten with the server admin to run a...

  • RE: Copy of 1 TB prod database

    tripleAxe (11/18/2015)


    Striping the backup to multiple backup files can help you reduce the backup/restore time.

    In my experience, I have seen no difference between restoring striped files and a single...

  • RE: DBA path discussion

    K. Brian Kelley (11/17/2015)


    The most overlooked area: "soft skills."

    - How clearly you can communicate.

    - How well you work with others.

    - How organized you are.

    Yes. And emotional intelligence is probably the...

  • RE: Are the posted questions getting worse?

    djj (11/17/2015)


    Lynn Pettis (11/17/2015)


    OMG

    Resume time.

    Not touching that one with a ten foot pole.

    Someone is probably getting fired.

Viewing 15 posts - 2,146 through 2,160 (of 9,707 total)