Forum Replies Created

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

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 18, 2015 at 1:05 pm

    #1840829

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 18, 2015 at 7:44 am

    #1840676

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 18, 2015 at 7:41 am

    #1840675

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 17, 2015 at 11:38 am

    #1840450

  • RE: Are the posted questions getting worse?

    Send some of that snow my way, Steve?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 17, 2015 at 6:24 am

    #1840302

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