Forum Replies Created

Viewing 15 posts - 5,956 through 5,970 (of 9,722 total)

  • RE: Are the posted questions getting worse?

    Jim Murphy (5/17/2011)


    Koen Verbeeck (5/17/2011)


    And now I've reached the 5000-points milestone.

    W00t w00t! :w00t: 😎 :hehe:

    Ahem.... Back to the tasks at hand... 😀

    Excellent! Good job helping the community.

    Wait. We're supposed...

    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 (5/17/2011)


    Data Analyst job will be opening up soon where I work (not mine) in Columbus, OH. Mostly report writing, some dev work in SSRS/SSIS, rest is trending patient utilization...

    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!

    SQLRNNR (5/17/2011)


    Ray K (5/17/2011)


    bcsims 90437 (5/17/2011)


    Daniel Bowlin (5/17/2011)


    SQLRNNR (5/17/2011)


    crookj (5/17/2011)


    SQLRNNR (5/17/2011)


    stick

    Shift

    clutch

    hitter

    pinch

    Hmmm, should I spend $60 to take me and my dog to the Dodgers game on Bark in the Park...

    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: Select Only IDs that match all entries in another table

    Stefan,

    I've actually had to do that at my work place. If those solutions don't work for some reason, let us know and I'll check my production environment to see what...

    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: Why is it that opening .sql files in a project requires signing in each time?

    It also depends on how you have your environment set up. You can find it in Tools-> Options. I use "Open Empty Environment" so I don't have to log into...

    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: Cluster Setup Fails always with 11004

    reido70 (5/17/2011)


    I dont know if stopping short of destroying the windows cluster and rebuilding it if there is a work around?

    So far as I know, you can't go back without...

    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: Looking for a data compare/copy product

    SQL Server 2008 Replication

    If you're looking to upgrade, it comes free with SQL Server 2008.

    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 we use more than one join for 2 tables

    Thanks, diamond, but I'm not enough of a geek to be able to easily translate that. Any chance you could explain what you just said using English examples?

    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: Primary Key Violation Frustration

    Thank you, Ninja. I appreciate the new info. I will definitely dig around.

    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: Primary Key Violation Frustration

    Oh, learning time.

    I've never heard the phrase "untrusted constraint." Please explain.

    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: Primary Key Violation Frustration

    Found the problem.

    The mapping table has duplicate new product numbers. I didn't see it because there are so many new products, and so few dups. And the dups each have...

    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 we use more than one join for 2 tables

    The problem is, we don't understand what you mean by N+1 JOIN conditions. Real life examples would help us give you the proper code. We're not asking about company data....

    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?

    Jack Corbett (5/16/2011)


    Saw Steve's mention of Denver for next year's US SQLRally, I say US because there is SQLRally Nordic in Sweden in November and I believe Australia is in...

    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 (5/16/2011)


    Brandie Tarvin (5/16/2011)


    Stefan Krzywicki (5/16/2011)


    Here's an interesting article on Oracle satisfaction[/url]

    SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for...

    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: Return rows affected by an UPDATE in an SP

    GilaMonster (5/16/2011)


    Brandie Tarvin (5/16/2011)


    Ray K (5/16/2011)


    When I tried calling the SP, I got the 'Must declare the scalar variable "@Result".' message.

    Declare @Result int;

    Execute TestProc 'ID','Email', @Result output;

    That's how you call...

    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,956 through 5,970 (of 9,722 total)