Forum Replies Created

Viewing 15 posts - 7,756 through 7,770 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/4/2010)

    Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn the OUTER JOINs...

    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 10:45 am

    #1202205

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/4/2010)

    Odds are by the time I've figured out how to word the

    question I'll have salved the problem I'm having.

    Are you using anti-biotic salve or a general "good...

    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 10:43 am

    #1202203

  • RE: Sql Managementstudio

    Can you open up remote desktop, hit your dev server, and open up SSMS that way?

    If so, I tend to agree that there might be something going on with 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 7:14 am

    #1202072

  • RE: what are credentials in sql server 2005

    Apparently you didn't read the first line of the second article.

    A credential is a record containing the authentication information needed to connect to a resource outside of SQL Server.

    Real life...

    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 7:10 am

    #1202069

  • RE: Maintenance Plan Errors

    Are you backing up to a network location? If so, check and make sure your destination still exists.

    Best practice is to backup locally and move a copy of the backup...

    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 7:02 am

    #1202060

  • 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

Viewing 15 posts - 7,756 through 7,770 (of 9,715 total)