Forum Replies Created

Viewing 15 posts - 6,976 through 6,990 (of 9,725 total)

  • 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

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (11/22/2010)

    CirquedeSQLeil (11/22/2010)

    Chris Morris-439714 (11/22/2010)

    Wishing Jack C a speedy recovery and some quality time for recuperation.

    Get well soon, mate.

    Did I miss something more than the burnout?

    Our DBA caught some...

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

    #1253856

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/22/2010)

    Alvin Ramard (11/22/2010)

    Brandie Tarvin (11/22/2010)

    I live in Florida now. Black Friday is not so bad when you can wait in line at 2:00 a.m. in only a jacket, t-shirt,...

    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 8:13 am

    #1253772

  • RE: Today's Random Word!

    holiday.

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

    #1253727

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (11/22/2010)

    GSquared (11/22/2010)

    LutzM (11/19/2010)

    Alvin Ramard (11/19/2010)

    ...

    It's a 3 day work week for many of us in the US. Thanksgiving is on Thursday.

    I hope you folks in the U.S. will...

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

    #1253726

  • RE: Are the posted questions getting worse?

    Chad Crawford (11/19/2010)

    GilaMonster (11/19/2010)

    Tom.Thomson (11/19/2010)

    You mean you want to be a year older? :laugh:

    I'd be a year older anyway (unless someone's planning on rolling back 2010), I just wouldn't...

    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 19, 2010 at 11:29 am

    #1253242

Viewing 15 posts - 6,976 through 6,990 (of 9,725 total)