Forum Replies Created

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

  • RE: help in my procedure

    Lamprey13 (12/16/2010)

    Brandie Tarvin (12/16/2010)[hrYou're missing the point of my comment. He's trying to match a potentially NULL value to another value. You can't do that with a function that is...

    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 11:30 am

    #1263628

  • RE: Are the posted questions getting worse?

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

    I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and someone adds a new...

    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 11:07 am

    #1263605

  • RE: help in my procedure

    Lamprey13 (12/16/2010)

    Anything you've read by Kimball should be forgotten. If you still have the book you read that in (assuming it was a book) you should burn it now to...

    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 11:00 am

    #1263596

  • RE: Not able to work on SSAS Cubes migrated from SQL 2000 to SQL 2005

    It would help if you provided the list of errors so we could help you better.

    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 10:54 am

    #1263590

  • RE: Today's Random Word!

    Daniel Bowlin (12/16/2010)

    Ray K (12/15/2010)

    sing4you (12/15/2010)

    Ray K (12/15/2010)

    Concert

    (as in I'm playing one tonight!)

    Cool! What are you playing?

    I just sang, played piano, and bass guitar (not all at the same...

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

    #1263461

  • 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

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