Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 9,726 total)

  • RE: Need answers for interview questions...

    Lynn Pettis (2/28/2012)


    GilaMonster (2/28/2012)


    satishm94 (2/28/2012)


    6)When updation & insertion is going on back job has to wait or not?

    Huh?

    Basically, do INSERTs and UPDATEs block a backup from running.

    Depends. How poorly...

    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.

  • RE: SSI Error

    Is it really a blank (as in spaces) or NULL values? There is a difference.

    Also, what is the source column data type and what is the destination column data type?

    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.

  • RE: Whats the difference between jobs and maintenance plan??

    satishm94 (2/27/2012)


    when u automate a backup strategy which one u choose in ur organization, and why??

    I don't automate backup strategies. I automate backups for a recovery strategy. And which one...

    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.

  • RE: some scripts

    If you want to share scripts, there are places to do that outside the forum itself (http://www.sqlservercentral.com/Scripts/%5B/url%5D).

    And Steve loves showcasing new scripts in the newsletter.

    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.

  • RE: need to copy 100 tables from 1 server/db to another server/db..

    The easiest way?

    I'd say restore the database to the other server and delete the unneeded tables. Which runs into problems if you delete FK related tables in the wrong...

    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.

  • RE: Adding a fresh table to replication subscription which is not from publisher

    Not that it should break replication unless you're connecting the new table to an existing "article" table, but ...

    Which side of replication are you intending to add the table?

    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.

  • RE: Need answers for interview questions...

    Koen Verbeeck (2/28/2012)


    GilaMonster (2/28/2012)


    satishm94 (2/28/2012)


    4)What is proxy server? Why do u need it?

    No such thing as a proxy server in SQL Server

    Maybe proxy accounts in SQL Agent?

    No. Based on 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.

  • RE: Are the posted questions getting worse?

    LutzM (2/27/2012)


    Koen Verbeeck (2/27/2012)


    ..

    This one obviously is (on another site):

    interview questions

    ...

    I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, 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.

  • RE: 2005 Setup Support Files Will Not Install

    Thank you for posting that.

    Anti-Virus software kills things every time. I have seen more problems caused by that... Sorry I didn't think about it in your 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.

  • RE: Query runs much slower when connect to SQL Server locally.

    Which node has the newer network driver? The slow one or the fast one?

    And what are your network card configurations for both servers?

    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.

  • RE: Are the posted questions getting worse?

    Congrats on the new job, Lynn. I love Colorado Springs. If I get a chance to move to Colorado, that's the city I want to live in.

    As close to 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.

  • RE: Are the posted questions getting worse?

    LutzM (2/25/2012)


    Jeff Moden (2/25/2012)


    Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.

    http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx

    <shudder>

    It becomes rather scary when seen in...

    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.

  • RE: How do I return only entries with multiple categories in a junction table?

    CELKO (2/24/2012)


    This is an environment that I INHERITED. I DID NOT BUILD THIS. This is based on a production environment, and I have limited leeway as to...

    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.

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    I've never actually run into the problem that Gail describes. I was just throwing out a W.A.G. as to what she could have meant. I'm sure she'll reply with more...

    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.

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    patrickmcginnis59 (2/24/2012)


    When thinking this through, slowness of the system in my mind brings things closer together instead of keeping things spread apart, as queries lasting longer by inference brings their...

    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.

Viewing 15 posts - 4,666 through 4,680 (of 9,726 total)