Forum Replies Created

Viewing 15 posts - 7,741 through 7,755 (of 9,725 total)

  • RE: Restart SQL Server service on a cluster environment

    free_mascot (8/4/2010)

    Andreea

    I would like to drow your attention that when you restart the server tempdb will shrink and when the space is required it has to expand. Now expanding 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 6, 2010 at 5:26 am

    #1203401

  • RE: Too old?

    Your comments make me wonder who it is that's saying you're too old for this. Are they peers of yours? Are they older? Or are they the "younger men" who...

    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 6, 2010 at 5:17 am

    #1203399

  • RE: SQL Server 2005 SP3 GDR (9.0.4053)

    If I'm understanding your question correctly, all Service Packs have previous fixes inclusive up to the current version #. So if you've never installed SP1 or SP2, you should be...

    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 6, 2010 at 5:11 am

    #1203393

  • RE: Default isolation level

    guptaajay1985 (8/6/2010)

    Default isolation level is?

    Have you tried looking it up in Books Online?

    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 6, 2010 at 5:10 am

    #1203391

  • RE: Cannot open database "ASPState" requested by the login. The login failed.

    Here's a link with a similar issue. Does it help?

    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 6, 2010 at 5:09 am

    #1203390

  • RE: Performance Issue in Insert Values

    One thing I'm suddenly confused about. 1) Why is a performance issue question in the Security forum?

    Back to the point, Doesn't the data being in different places, pointers 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 6, 2010 at 5:06 am

    #1203389

  • RE: Performance Issue in Insert Values

    GilaMonster (8/6/2010)

    Brandie Tarvin (8/6/2010)

    I have to wonder how many times a single record is split because not all the data will fit on a page.

    Not permitted (except row overflow 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.

    August 6, 2010 at 4:49 am

    #1203378

  • RE: Inception

    I get my ideas from words. Words just trigger some sort of bizarre mental process in me that sparks my creative side. Whether I'm having / overhearing a conversation, listening...

    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 6, 2010 at 4:46 am

    #1203375

  • RE: Today's Random Word!

    Drain Bramage!

    I wonder how many people will recognize where that phrase came from. @=)

    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 6, 2010 at 4:31 am

    #1203364

  • RE: Are the posted questions getting worse?

    Good luck to Steve on the PASS interview. Jack, I'm sure yours went fine.

    And I'm glad my taboo tech discussion helped someone and spawned even further interesting discussions. @=) ...

    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 6, 2010 at 4:29 am

    #1203362

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/5/2010)

    Well, getting really short here, tomorrow is my last day with my current employer!

    Wish me luck!!

    ACK! Lynn has Shorttimers Disease!

    Much luck on your new position. @=)

    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 6, 2010 at 4:26 am

    #1203360

  • RE: Performance Issue in Insert Values

    In addition to the index problem, having 100 columns in a table just by itself will cause performance problems. I have to wonder how many times a single record 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.

    August 6, 2010 at 4:24 am

    #1203356

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (8/5/2010)

    Jack Corbett (8/5/2010)

    ...

    Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a column 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.

    August 5, 2010 at 8:13 am

    #1202773

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (8/5/2010)

    What creeps me out is when I left-join a child table to a parent, then inner join child to a grandchild, with no reference to either 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 5, 2010 at 8:11 am

    #1202768

  • RE: Today's Random Word!

    Ice

    Twenty minutes on, twenty minutes off. Repeat about three times.

    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 5, 2010 at 7:51 am

    #1202749

Viewing 15 posts - 7,741 through 7,755 (of 9,725 total)