Forum Replies Created

Viewing 15 posts - 6,826 through 6,840 (of 9,715 total)

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

    The key to keeping your throat from getting sore is to not swallow that stupid frog in the first place!

    😛

    Actually, the breathing thing I mentioned on page one 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 16, 2010 at 7:39 am

    #1263456

  • RE: Are the posted questions getting worse?

    GSquared (12/16/2010)

    I used to know a DBA who insisted on using 1-letter aliases for all tables in queries, because it made them "faster to type" in the other parts 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 16, 2010 at 7:27 am

    #1263449

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (12/16/2010)

    Brandie Tarvin (12/16/2010)

    So, I have this query that yesterday is working fine and quick when I left out......

    <Snip>

    It's going to be one of those weeks, isn't it?

    Sounds dangerously...

    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 6:20 am

    #1263408

  • RE: Are the posted questions getting worse?

    So, I have this query that yesterday is working fine and quick when I left outer join three tables. But when I change them over to inner joins takes forever...

    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 6:05 am

    #1263399

  • RE: help in my procedure

    Gianluca Sartori (12/16/2010)

    CELKO (12/15/2010)

    3) Why are you wasting time with dynamic SQL?

    Actually, dynamic SQL is the most efficient way to handle optional parameters in stored procedures.

    Using COALESCE, ISNULL, CASE...

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

    #1263383

  • 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

Viewing 15 posts - 6,826 through 6,840 (of 9,715 total)