Forum Replies Created

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

  • RE: Today's Random Word!

    pastries

    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 21, 2010 at 7:36 am

    #1265073

  • RE: SSAS & Week()

    DOH. I wrote the original query wrong in this thread. I did use Datepart. Honest.

    Still odd how it transformed it, though.

    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 17, 2010 at 7:27 am

    #1264059

  • RE: Are the posted questions getting worse?

    Tom.Thomson (12/16/2010)

    And on coalesce, you were just making yourself look silly. Don't let the fact that Celko often (usually?) writes in online fora as an obnoxious *** blind you...

    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 17, 2010 at 7:23 am

    #1264056

  • RE: SSAS & Week()

    No. I don't use keywords or functions for column & table names.

    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 17, 2010 at 4:19 am

    #1263992

  • RE: Today's Random Word!

    crookj (12/16/2010)

    WOTD - MM's

    (De Plain - Office gift - Wishing for the other type)

    Email them over to me. I'll eat them. @=)

    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 12:42 pm

    #1263660

  • 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

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