Forum Replies Created

Viewing 15 posts - 6,841 through 6,855 (of 9,725 total)

  • RE: help in my procedure

    WayneS (12/15/2010)

    CELKO (12/15/2010)

    >> There's math problems with money? Please, do tell. I haven't heard anything about them and as I use that field [sic: columns are not fields] quite 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.

    December 16, 2010 at 5:11 am

    #1263381

  • RE: help in my procedure

    CELKO (12/15/2010)

    >> Now Microsoft may or may not have implemented COALESCE() by ANSI-Standards. I don't know. But given that no one can compare one unknown value (NULL) to another unknown...

    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.

    December 16, 2010 at 5:10 am

    #1263380

  • RE: Today's Random Word!

    Congrats, Tom. Remember to spoil her properly now.

    WOTD: Spoil

    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.

    December 16, 2010 at 4:29 am

    #1263374

  • RE: Error in SSIS Package

    Please start a new topic for your 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.

    December 16, 2010 at 4:23 am

    #1263372

  • RE: Are the posted questions getting worse?

    I think I just found it. Money rounds funny when being used in division and multiplication.

    Interesting that I never ran into this before. I should make a SQL Server 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.

    December 15, 2010 at 12:19 pm

    #1263072

  • RE: Are the posted questions getting worse?

    Not believing I'm actually going to get an answer to the question I posted on the thread Wayne just linked, I'm going to ask the question here.

    Has anyone heard 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.

    December 15, 2010 at 11:53 am

    #1263059

  • RE: help in my procedure

    CELKO (12/15/2010)

    Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are.

    Sample data is also...

    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.

    December 15, 2010 at 11:45 am

    #1263056

  • RE: help in my procedure

    CELKO (12/15/2010)

    5) Why did you use MONEY? Do you know about the math problems it has?

    There's math problems with money? Please, do tell. I haven't heard anything about them and...

    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.

    December 15, 2010 at 11:42 am

    #1263053

  • RE: Are the posted questions getting worse?

    Paul White NZ (12/15/2010)

    On the other hand, IN and EXISTS have slightly different NULL-handling semantics, so it is not possible to express the exact same logic using IN as 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.

    December 15, 2010 at 8:26 am

    #1262894

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (12/15/2010)

    da-zero (12/15/2010)

    I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.

    :rolleyes:

    Agreed on the interesting advertisement. Is the book bad?

    If I'm...

    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.

    December 15, 2010 at 8:12 am

    #1262874

  • RE: Today's Random Word!

    We just got a Phoo place in Jax that I'm dying to try out.

    I miss our Mongolian BBQ. Used to have one near our house that was out of 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.

    December 15, 2010 at 7:43 am

    #1262851

  • RE: DSV Named Query vs SSIS Data Flow

    Well, the source database is already a day behind production. So I need to find out how often the cube will be reprocessed. Or, more accurately, how often the reports...

    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.

    December 15, 2010 at 6:55 am

    #1262809

  • RE: How to prevent a sore throat after hours of presenting ppt ?

    You're welcome.

    There are a few other things I should mention.

    Don't drink high amounts of caffeine before a presentation. It dries out your throat. Don't drink anything cold before 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.

    December 15, 2010 at 6:11 am

    #1262784

  • RE: Are the posted questions getting worse?

    GilaMonster (12/15/2010)

    Chris Morris-439714 (12/15/2010)

    I *think* Gail has blogged on this, will look.

    http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

    http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/

    Wow. It's like Gail has indexed her blog or something... @=)

    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.

    December 15, 2010 at 5:28 am

    #1262762

  • RE: Backup Types

    What do you want to know?

    The easiest way to learn the basics is to look up Partial Backup in Books Online. But if you've already done that and have specific...

    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.

    December 15, 2010 at 5:28 am

    #1262761

Viewing 15 posts - 6,841 through 6,855 (of 9,725 total)