Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 9,715 total)

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

    November 18, 2015 at 7:40 am

    #1840672

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

    November 18, 2015 at 7:37 am

    #1840670

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

    November 18, 2015 at 5:31 am

    #1840612

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

    November 18, 2015 at 4:33 am

    #1840593

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

    November 18, 2015 at 4:30 am

    #1840591

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

    November 18, 2015 at 4:26 am

    #1840590

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

    November 17, 2015 at 11:40 am

    #1840451

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

    November 17, 2015 at 11:38 am

    #1840450

  • RE: Are the posted questions getting worse?

    Send some of that snow my way, Steve?

    November 17, 2015 at 11:38 am

    #1840449

  • RE: Copy of 1 TB prod database

    If you only need to restore once every two weeks, then restoring off the production backups (as Gail suggested) is your best bet.

    Create a T-SQL job that is scheduled...

    November 17, 2015 at 10:31 am

    #1840422

  • RE: Backup file logical Names

    As Anthony said, you need to talk to the person providing these backups to you.

    EDIT: To be clear, unzipping a file does not "create" a backup file. What's happening is...

    November 17, 2015 at 8:42 am

    #1840372

  • RE: Are the posted questions getting worse?

    GilaMonster (11/17/2015)

    The heatwave here has just broken, yesterday was the first rain for almost a month and a half (in our peak rainfall season). It's been seriously unpleasant here since...

    November 17, 2015 at 6:24 am

    #1840302

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/17/2015)

    Brandie Tarvin (11/17/2015)

    Ed Wagner (11/17/2015)

    Lynn Pettis (11/16/2015)

    Ed Wagner (11/16/2015)

    Lynn Pettis (11/16/2015)

    And then you this type of question:

    ************(11/16/2015)

    How can i round off decimal number. E.g if i have 7.9---i...

    November 17, 2015 at 6:23 am

    #1840301

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/17/2015)

    Lynn Pettis (11/16/2015)

    Ed Wagner (11/16/2015)

    Lynn Pettis (11/16/2015)

    And then you this type of question:

    ************(11/16/2015)

    How can i round off decimal number. E.g if i have 7.9---i need to round it...

    November 17, 2015 at 5:37 am

    #1840286

  • RE: Backup file logical Names

    How are your backups being done? Is it a SQL Server maintenance job? Is it a third party tool? Is it a T-SQL job you created?

    November 17, 2015 at 5:27 am

    #1840283

Viewing 15 posts - 2,161 through 2,175 (of 9,715 total)