Forum Replies Created

Viewing 15 posts - 7,171 through 7,185 (of 9,720 total)

  • RE: How to create new instance in sql server 2005

    Is there a difference between the service accounts used for the other instances and this one?

    If so, are you sure the accounts have the necessary permissions for installation?

    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?

    Brandie Tarvin (10/19/2010)


    GilaMonster (10/19/2010)


    Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspx

    Added in a second penny. Hopefully that'll equal two cents worth.

    And he seems to have responded well to all our responses. He'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.

  • RE: Are the posted questions getting worse?

    GilaMonster (10/19/2010)


    Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspx

    Added in a second penny. Hopefully that'll equal two cents worth.

    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: Maintenance Plans in SQL 2005

    In addition to the maintenance plans listed above, you should also code a job that checks file sizes verses available disk space to make sure you aren't running out of...

    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: Calling a Stored Procedure inside a stored procedure

    A few notes. Use Truncate instead of Delete. Truncate logs only the extents being deleted, not the entire record like Delete does. Hence, it's quicker. Also, be aware that using...

    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: Calling a Stored Procedure inside a stored procedure

    Quick note that has nothing to do with resolving your problem, but could save you a lot of typing. You don't have to Declare each variable on a separate statement....

    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: SSIS Insert Violation of PRIMARY KEY constraint during insert on SSIS

    The only thing I can think of at this point is either that the GUIDs already exist in the table that you're trying to load the Excel sheet into 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.

  • RE: How to truncate log file in SQL Server 2005

    Please start a new thread for your question. Most people consider this one resolved and won't answer.

    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: Today's Random Word!

    blather

    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?

    Stefan Krzywicki (10/18/2010)


    Which is great and correct for light, but pigment is exactly the opposite. White is an absence of all pigment, black is a combination of all pigment.

    Not quite...

    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?

    Stefan Krzywicki (10/18/2010)


    The Dixie Flatline (10/18/2010)


    I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?

    My opinion is that brothers...

    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?

    The Dixie Flatline (10/18/2010)


    I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?

    How about scientific fact?

    Color is just 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: SSIS Insert Violation of PRIMARY KEY constraint during insert on SSIS

    Brandie Tarvin (10/18/2010)


    As far as your primary key violation goes... Is the GUID in the Excel file or are you defaulting on that?

    Please answer this question.

    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?

    Steve Jones - SSC Editor (10/18/2010)


    Aren't most trees green?

    Ahem. Trees are brown (some are white). The leaves (or needles) are green.

    There's a difference. @=)

    EDIT: Opps. Missed your rebuttal. Still stand...

    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: You'd think I'd have learned...

    Adding an aggregate to previously-coded statements and forgetting to add a Group By.

    DOH.

    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 - 7,171 through 7,185 (of 9,720 total)