Forum Replies Created

Viewing 15 posts - 7,771 through 7,785 (of 9,725 total)

  • RE: SQL Server Installation

    I'm going to say yes. Even if C: and D: are separate physical drives instead of logical drive partitions on the same drive, SQL Server puts registry keys into 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.

    August 4, 2010 at 6:57 am

    #1202057

  • RE: SQL Server And Oracle

    Grant Fritchey (8/4/2010)

    Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old...

    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.

    August 4, 2010 at 6:52 am

    #1202052

  • RE: Monitoring Tempdb - Does this script help? Please advice

    A note of interest. One of our more SAN-Experienced DBAs told me a few months ago that a SAN might also only have one controller, no matter how many physical...

    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.

    August 4, 2010 at 6:49 am

    #1202050

  • RE: Maintaining a live copy of data in a test database

    Animal Magic (8/4/2010)

    the reason i need live data to be refereshed on a daily basis is because often when testing the users will want to use the same data that...

    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.

    August 4, 2010 at 5:36 am

    #1201992

  • RE: Index defrag

    GilaMonster (8/4/2010)

    Brandie Tarvin (8/4/2010)

    "Blocking" isn't a simple issue to assist with on the forums. Once you track down what's being blocked, you can start troubleshooting to find out what it's...

    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.

    August 4, 2010 at 5:30 am

    #1201987

  • RE: SQL Server Mirroring

    Lazy DBA (8/3/2010)

    Is it possible to setup the mirroring without joining the servers on a domain? If not, is it must for servers to be part of same domain?

    What do...

    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.

    August 4, 2010 at 4:48 am

    #1201975

  • RE: Index defrag

    Mani-584606 (8/3/2010)

    Because we are facing blocking problem for the content database and assuming it's due to index fragmentation?

    Is that blocking is due to index fragmentation? please advice?

    Never assume. It's...

    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.

    August 4, 2010 at 4:46 am

    #1201974

  • RE: Monitoring Tempdb - Does this script help? Please advice

    iqtedar (8/3/2010)

    In this test i only need to decide whether moving tempdb data file to another drive has it improved the performance or not.

    Bhuvnesh (8/4/2010)

    Spliting file definitely helps you.

    Not...

    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.

    August 4, 2010 at 4:40 am

    #1201972

  • RE: SQL Server And Oracle

    Depends on the latency requirements and "when" they need the data. Can this be something you transfer to them on a nightly basis using SSIS? Or is this a situation...

    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.

    August 4, 2010 at 4:36 am

    #1201969

  • RE: Maintaining a live copy of data in a test database

    Honestly, I think you're approaching your problem the wrong way. You shouldn't need live data *every* day to have a Dev database. And whether or not you script it or...

    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.

    August 4, 2010 at 4:35 am

    #1201968

  • RE: Cannot maintain big database......

    jeff.mason (8/3/2010)

    Not all of these are for 2008 ...

    Jeff, this is the 2005 forum, not the 2008 forum. @=)

    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.

    August 4, 2010 at 4:26 am

    #1201964

  • RE: Today's Random Word!

    And my phrase for the day.

    "Official Secrets Act"

    HA!

    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.

    August 4, 2010 at 4:25 am

    #1201962

  • RE: Are the posted questions getting worse?

    Oh, switching topics.

    We had the best Mongolian BBQ place in town a few years back. Now it's gone. I miss it so much. I need to track down a new...

    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.

    August 4, 2010 at 4:24 am

    #1201961

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (8/3/2010)

    There are plenty more examples of religion associated acts of terror too (Holocaust....

    I have to disagree with this statement. As an amateur historian, I don't see the Holocaust as...

    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.

    August 4, 2010 at 4:22 am

    #1201959

  • RE: Cannot maintain big database......

    espanolanthony (8/3/2010)

    I haven't heard about "reindex by filegroup". Please highlight how to do it. and yes i have 1 mdf, 1 ndf and 1 ldf. So how do...

    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.

    August 3, 2010 at 12:18 pm

    #1201729

Viewing 15 posts - 7,771 through 7,785 (of 9,725 total)