Forum Replies Created

Viewing 15 posts - 6,961 through 6,975 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (11/29/2010)

    Alvin Ramard (11/29/2010)

    It's time for the business owners to try and figure out what they forgot in the requirements.

    What requirements?

    Shame. Have you two forgotten this is a family-friendly forum?

    Quit...

    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.

    November 29, 2010 at 11:02 am

    #1256372

  • RE: Today's Random Word!

    Tom.Thomson (11/29/2010)

    and it's cold (about 67ºF); Ann and I had been in the UK for 9 days, freezing our butts off and praying (in vain) for some sun, and got...

    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.

    November 29, 2010 at 10:26 am

    #1256341

  • RE: Today's Random Word!

    Tom.Thomson (11/29/2010)

    Brandie Tarvin (11/29/2010)

    Post-Holiday Blues.

    Hrm. That's more than one word. ... Let me try that again.

    WOTD: Morning?

    Surely "Mourning" (for the end if the holiday)

    HA! That's it exactly!

    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.

    November 29, 2010 at 8:02 am

    #1256273

  • RE: Today's Random Word!

    Post-Holiday Blues.

    Hrm. That's more than one word. ... Let me try that again.

    WOTD: Morning?

    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.

    November 29, 2010 at 5:45 am

    #1256190

  • RE: Are the posted questions getting worse?

    Hope everyone enjoyed their long weekend (those of us who got one).

    In the spirit of changing the water cooler topic (and for those who missed the thread I posted this...

    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.

    November 29, 2010 at 5:43 am

    #1256187

  • RE: Remove duplicate records based on record id, annoying GROUP BY statement

    It's always good to keep the original data of the table stashed in a different DB / different table just in case you have to restore data from that 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.

    November 29, 2010 at 5:13 am

    #1256177

  • RE: Datbase is in Suspect mode

    homebrew01 (11/23/2010)

    When I have a job that I want disabled for a period of time. instead of disabling it, I often change the start date to a future date, so...

    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.

    November 23, 2010 at 10:09 am

    #1254577

  • RE: Are the posted questions getting worse?

    Oddly enough, I know a lot of DBAs & Devs who use SELECT DISTINCT out of nothing more habit. It's not that they need to do it. They just assume...

    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.

    November 23, 2010 at 8:05 am

    #1254479

  • RE: Are the posted questions getting worse?

    Glad you're out of the hospital, Jack. I hope you're feeling better.

    Try to have a little fun at work if it's less stressful then the kids. And if you need...

    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.

    November 23, 2010 at 6:57 am

    #1254424

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (11/23/2010)

    I personally liked all the select distincts.

    That usually seems to indicate a missing join, or you might need to review the design of the db.

    Or that someone's doing...

    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.

    November 23, 2010 at 6:37 am

    #1254410

  • RE: Work around for SQL server performance issue

    A few more comments on your code. Look at your first three insert statements. Remove the subqueries, do LEFT OUTER JOINS with the subqueries, and look at making all three...

    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.

    November 23, 2010 at 5:41 am

    #1254368

  • RE: Work around for SQL server performance issue

    Gangadhara MS (11/21/2010)

    I have followed the same steps and found that some stored procedures having highest duration abnd IO/CPU.

    But my developer saying i can't further tune with query 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.

    November 23, 2010 at 5:26 am

    #1254363

  • RE: Today's Random Word!

    shopping

    (for holiday eats)

    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.

    November 23, 2010 at 4:31 am

    #1254324

  • RE: Are the posted questions getting worse?

    Thanks, Gail. I can't check twitter while I'm at work.

    "Stress is the universe's way of telling you to sloooooooooow doooooooooooown."

    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.

    November 22, 2010 at 10:48 am

    #1253883

  • RE: Today's Random Word!

    Tofurkey

    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.

    November 22, 2010 at 10:09 am

    #1253857

Viewing 15 posts - 6,961 through 6,975 (of 9,715 total)