Forum Replies Created

Viewing 15 posts - 7,246 through 7,260 (of 9,715 total)

  • RE: Query tuning - avoid Case statement on this query

    This might explain the difference between what you're saying and what you're seeing.

    Brad

    ...not every WHERE clause that has a non-sargable expression in it is doomed to a table/index scan. If...

    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.

    October 12, 2010 at 8:41 am

    #1235584

  • RE: Are the posted questions getting worse?

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

    jcrawf02 (10/12/2010)

    At the risk of encountering a porcine missile, have you ever heard of earplugs? 😀

    I have found that single rooms are the best earplugs...

    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.

    October 12, 2010 at 7:43 am

    #1235519

  • RE: Today's Random Word!

    Congrats indeed! That's a wonderful milestone.

    Only 82 more years to go. @=)

    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.

    October 12, 2010 at 7:08 am

    #1235487

  • RE: Today's Random Word!

    Rutabaga

    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.

    October 12, 2010 at 5:52 am

    #1235425

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

    liewsb (10/11/2010)

    Hi Gail,

    I will carry out to shrink the log file this morning, here are the steps to carry out:

    1. Change the Database recovery model to simple.

    2. Execuate checkpoint command;

    3....

    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.

    October 12, 2010 at 5:49 am

    #1235420

  • RE: How to get unique value from a records from multiple columns

    You're welcome. Let us know if you need anything else.

    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.

    October 12, 2010 at 5:39 am

    #1235412

  • RE: Are the posted questions getting worse?

    Paul White NZ (10/11/2010)

    Jack Corbett (10/11/2010)

    $3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.

    A cheaper room-mate? :blink:

    Hey! 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.

    October 12, 2010 at 5:34 am

    #1235410

  • RE: Restore from LiteSpeed

    If you're going to use the backup on another server, rather than the server the backup was saved to, I recommend moving the backup file *before* converting it to a...

    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.

    October 12, 2010 at 4:14 am

    #1235386

  • RE: How to get unique value from a records from multiple columns

    Then I suggest doing more of a normalized set up with all the "main" part numbers in one table and all the alternate part numbers in a reference table.

    Just an...

    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.

    October 8, 2010 at 12:49 pm

    #1234468

  • RE: How to get unique value from a records from multiple columns

    I accidently hit enter on this post.. wish I could have deleted it.

    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.

    October 8, 2010 at 12:38 pm

    #1234465

  • RE: How to get unique value from a records from multiple columns

    Yikes. You're trying to eliminate cascading values? That's not nearly as easy as you presented it and changes both answers you've received on this thread.

    Leaning towards Celko on 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.

    October 8, 2010 at 12:23 pm

    #1234452

  • RE: Backup Types

    I'm glad the question has helped so many people. I did not realize how few people knew about File and Partial backups.

    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.

    October 8, 2010 at 12:03 pm

    #1234431

  • RE: Are the posted questions getting worse?

    Ray K (10/8/2010)

    Gianluca Sartori (10/8/2010)

    At last, Mr. Celko gives a polite and useful answer to a poor-worded question.

    It's nice to see everyone can learn.

    I don't know. I sensed a...

    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.

    October 8, 2010 at 11:53 am

    #1234426

  • RE: How to get unique value from a records from multiple columns

    I noticed, in your example, you only listed two of the unique numbers instead of all four. Is there a reason why the other two numbers should not come up...

    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.

    October 8, 2010 at 11:52 am

    #1234425

  • RE: Database Goes Missing

    Oh. Sorry. I'm having a weird Friday.

    I have not yet tested File Watcher. I'll check into that as soon as I get a chance. Have you tested it yet?

    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.

    October 8, 2010 at 11:39 am

    #1234414

Viewing 15 posts - 7,246 through 7,260 (of 9,715 total)