Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 9,726 total)

  • RE: Are the posted questions getting worse?

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


    Guy missing 60 cpus! Don't know how to help.

    http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx

    Did he feed them after midnight or get water on them?

    SET Snark = OFF;

    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?

    L' Eomot Inversé (11/14/2011)


    Brandie Tarvin (11/14/2011)


    Especially when DBAs are forced to use vendor databases over which they have little schema control. Don't beat up the people who have to deal...

    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?

    WOW...

    ...just... WOW.

    EDIT: In regards to all the MERGE connect bug issues, 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.

  • RE: Are the posted questions getting worse?

    After looking at the link Remi posted, and noticing the MERGE answer there, I have to wonder. For a simple one or two table update like that, is MERGE really...

    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 my SELECT query slower when the table is indexed?

    Thanks for your input, Gail. I appreciate it.

    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?

    Depends on the database, the environment, and the DBA / Dev, Tom.

    If you don't ever do anything with partitioning, and don't have a database big enough for that sort...

    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?

    GilaMonster (11/14/2011)


    SQLRNNR (11/13/2011)


    I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name.

    Likewise and a waste of time when typing 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: Why is my SELECT query slower when the table is indexed?

    raotor (11/11/2011)


    Brandie Tarvin (11/11/2011)


    The transaction will continue to run until it's completely rolled back. Rollbacks can take a while, just like the initial execution. It depends on how far 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: Are the posted questions getting worse?

    Brandie Tarvin (11/11/2011)


    Lynn Pettis (11/11/2011)


    What other Threadizins are participating in the DBA in Space contest? Looking for launch buddies!

    That's my plan for this afternoon is to get signed 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.

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/11/2011)


    What other Threadizins are participating in the DBA in Space contest? Looking for launch buddies!

    That's my plan for this afternoon is to get signed up and catch...

    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: Second Pair of Eyes, Please

    Ah. I made a couple of different errors on the above code (non-syntax). I'll post a corrected version up later for anyone wanting to use it.

    EDIT:

    Corrected code that prints 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: Understand this SQL Script

    What GSquared said.

    FYI: Depending on the business, you could get fired for uploading a database onto the internet. Engage in CYA. Post sample tables and sample data insert scripts...

    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: Second Pair of Eyes, Please

    GAH!

    Thank you, guys. I knew it was something simple.

    EDIT: I was also looking at the wrong bit of code in my error search.. DOH.

    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: Putting a condition on a subgroup to query result

    Given the scenario, this sounds like a homework 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.

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/11/2011)


    Brandie Tarvin (11/11/2011)


    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    Congrats! I don't know how you do it AND keep up with...

    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,116 through 5,130 (of 9,726 total)