Forum Replies Created

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

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

    November 14, 2011 at 5:33 am

    #1407086

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

    November 14, 2011 at 5:30 am

    #1407083

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

    November 14, 2011 at 4:46 am

    #1407062

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

    November 14, 2011 at 4:36 am

    #1407059

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

    November 11, 2011 at 9:19 am

    #1406378

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

    November 11, 2011 at 9:15 am

    #1406375

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

    November 11, 2011 at 8:56 am

    #1406351

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

    November 11, 2011 at 8:42 am

    #1406342

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

    November 11, 2011 at 8:33 am

    #1406333

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

    November 11, 2011 at 8:28 am

    #1406327

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

    November 11, 2011 at 8:07 am

    #1406295

  • RE: Are the posted questions getting worse?

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

    Roy Ernest (11/11/2011)

    Brandie Tarvin (11/11/2011)

    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA...

    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.

    November 11, 2011 at 7:51 am

    #1406272

  • RE: Why is my SELECT query slower when the table is indexed?

    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 initial transaction went....

    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.

    November 11, 2011 at 7:31 am

    #1406253

  • RE: Are the posted questions getting worse?

    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    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.

    November 11, 2011 at 7:28 am

    #1406249

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

    Glad you found a solution, even if it doesn't help you right now.

    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.

    November 11, 2011 at 6:24 am

    #1406204

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