Forum Replies Created

Viewing 15 posts - 6,856 through 6,870 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    Wow. I just had the worst time trying to post to Grant's blog. Three times I had to try before my post went through.

    You'd think he was throwing a contest...

    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.

  • RE: Are the posted questions getting worse?

    Change of subject. Someone posted an interesting link on Twitter last week that I retweeted. It's about Wikileaks from a security standpoint. I thought you might find the blog interesting.

    http://www.schneier.com/blog/archives/2010/12/wikileaks_1.html

    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.

  • RE: DSV Named Query vs SSIS Data Flow

    So.... You're advocating that I use SSIS to create the table first?

    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.

  • RE: Remove duplicate records based on record id, annoying GROUP BY statement

    petervdkerk (12/12/2010)


    I want the statement to be flexible and if I later add columns to the database, I dont want to have to alter the query to include the newly...

    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.

  • RE: Can I tune this?

    LutzM (12/10/2010)


    Craig Farrell (12/10/2010)


    ... I'd mention them but I'm not entirely sure I'm not barking up the wrong tree. 🙂

    Unlikely. The tree is already occupied and I can't...

    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.

  • RE: unable to preview the report in SSRS 2008

    Have you registered the .dll as I first suggested?

    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.

  • RE: unable to preview the report in SSRS 2008

    Do you know what parameter the error message is referring to?

    EDIT: This is an old thread, but it might be able to help you. http://www.bigresource.com/Tracker/Track-ms_sql-0kT9qz2f/%5B/url%5D

    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.

  • RE: Today's Random Word!

    Ray K (12/10/2010)


    crookj (12/10/2010)


    Brandie Tarvin (12/10/2010)


    crookj (12/10/2010)


    Was sick home yesterday and not fealing much better today. :sick:

    Sorry to hear that. Drink lots of hot liquids. That might warm you up.

    Thanks...

    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.

  • RE: Can I tune this?

    LutzM (12/10/2010)


    A similar option would be adding another table CoverageVersionsHistory with the current CoverageVersions structure and move all outdated versions into this history table on a scheduled base.

    Yeah, but...

    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.

  • RE: Can I tune this?

    LutzM (12/10/2010)


    You get a table scan because your subquery has no limiting WHERE condition. In order to find max(Effective) per CoverageKey you'd need to scan the entire table (or clustered...

    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.

  • RE: Are the posted questions getting worse?

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


    Plus for me it's during the week travel, which can be a bigger impact on my life as my wife travels.

    Horses don't feed themselves.

    @=)

    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.

  • RE: unable to preview the report in SSRS 2008

    Copying .dlls may not be sufficient. Some of them need to be registered.

    EDIT: Did you just copy stuff from the other machine or do you actually have SSRS installed on...

    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.

  • RE: Adding a new cube to a SSAS DB w/o re-processing all?

    Management Studio allows for the creation of SSAS databases, but not the cubes themselves.

    As far as processing cubes, I thought they only processed one at a time. But I never...

    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.

  • RE: How to remove relationships in *cube*, not dsv?

    The relationships in my cube seem based on the DSV relationships I set up. When I right-click those lines, they give me the option of editing the DSV.

    When 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.

  • RE: Today's Random Word!

    crookj (12/10/2010)


    Was sick home yesterday and not fealing much better today. :sick:

    Sorry to hear that. Drink lots of hot liquids. That might warm you 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.

Viewing 15 posts - 6,856 through 6,870 (of 9,715 total)