Forum Replies Created

Viewing 15 posts - 5,131 through 5,145 (of 9,715 total)

  • RE: ??Bug in ROW_NUMBER() + Partition BY in CTE

    Remi,

    Silly question. Why are you turning an OUTER JOIN into an INNER JOIN by adding C2.NoArticle to your WHERE clause?

    Would that have anything to do with your issue?

    EDIT: I'm not...

    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?

    Stefan Krzywicki (11/9/2011)

    I didn't have any problems when I submitted my articles. I did it through the editor. I guess I got lucky.

    It's been a while since I've submitted, 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: Reporting service performance

    If you've never done load balancing testing before, I suggest you don't schedule the reports to run simultaneously until after you've taken a baseline performance test of each individual report....

    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?

    GSquared (11/9/2011)


    GilaMonster (11/9/2011)


    Ninja's_RGR'us (11/9/2011)


    Am I the only 1 who wants to answer... if you don't know that, then why are you teaching this stuff??

    http://www.sqlservercentral.com/Forums/Topic1202806-150-1.aspx

    Haven't you forgotten the old saying -...

    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: Reporting service performance

    Talk to the people who set up SSRS for you. Ask them to help you load test 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.

  • RE: Are the posted questions getting worse?

    FYI

    Here's an article on Denali prices and licensing info:

    http://redmondmag.com/articles/2011/11/05/microsoft-unveils-sql-server-2012-licensing-and-pricing.aspx

    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?

    Roy Ernest (11/8/2011)


    Hey everyone, I am hijacking the thread with an "Off Topic"

    I am planning on a presentation for my user group "DBA MythBusters" (Courtesy Paul Randal) His idea 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.

  • RE: Comparing 2 Tables

    Sean Lange (11/7/2011)


    Brandie Tarvin (11/7/2011)


    Sean Lange (11/4/2011)


    Sounds like you need the cascading delete and an insert trigger on the master. In your trigger just insert into the peer review table...

    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: SSIS inserts are very slow

    I will let you argue the point with the man I learned this from, Brian Knight. Talk to him.

    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?

    Stefan Krzywicki (11/7/2011)


    ... The repeated "DISTINCTS" are a little weird...

    I've actually run into situations where I need duplicate DISTINCTs because of the way the data comes out of a complicated...

    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?

    Koen Verbeeck (11/7/2011)


    Stefan Krzywicki (11/7/2011)


    But there isn't a 2008 SSIS forum!

    No, but there is a general SSIS forum in the Data Warehouse section 🙂

    (to be honest, that forum is not...

    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?

    jcrawf02 (11/7/2011)


    SQLRNNR (11/4/2011)


    SQL Kiwi (11/4/2011)


    SQLRNNR (11/4/2011)


    Cadavre (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn'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: Sort objecst in Object Explorer

    Sorry it took me so long to respond. I've been busy.

    I appreciate the answers, but I'm not sure you understand what I'm looking for. I want to fiddle with the...

    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: Comparing 2 Tables

    Sean Lange (11/4/2011)


    Sounds like you need the cascading delete and an insert trigger on the master. In your trigger just insert into the peer review table the new metric. No...

    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: SSIS inserts are very slow

    Alexander Suprun (11/4/2011)


    Stefan Krzywicki (11/3/2011)


    Brandie Tarvin (11/3/2011)


    I forgot to mention something.

    If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow...

    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 - 5,131 through 5,145 (of 9,715 total)