Forum Replies Created

Viewing 15 posts - 6,421 through 6,435 (of 9,715 total)

  • RE: Can I tune this?

    Thank you all for answering my questions. I appreciate it. I never viewed indexes that way before. I guess I still have a lot to learn.

    And I forgot to try...

    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?

    Ian Scarlett (2/18/2011)


    Gianluca Sartori (2/18/2011)


    Do you remember Lennie, the guy with sock-puppets friends?

    He's back again. Nothing worth worrying about, at the moment.

    http://www.sqlservercentral.com/Forums/Topic1066085-9-1.aspx

    And I was unfortunate to see this post AFTER...

    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?

    Craig Farrell (2/17/2011)


    GSquared (2/17/2011)


    Alvin Ramard (2/17/2011)


    They exchange camels too??

    Yes, at camelsexchange.com. :w00t:

    Daddy, why's that boy camel wearing pink? Don't worry, son, he's just confused. There's a website 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: Are the posted questions getting worse?

    You people are strange.

    @=)

    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?

    Paul,

    On your blog, you state:

    Impressively, the estimated execution cost for the original query was about 0.007; for the “Segment Top” plan, the estimated cost is about 0.006 - slightly...

    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!

    CirquedeSQLeil (2/17/2011)


    Artificially unintelligent

    Military intelligence

    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?

    Paul,

    What is the effect of building a non-clustered index over a clustered index?

    The table already uses CoverageKey and Effective (both ASC) as it's clustered index. Include only works on non-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: failed the pre-execute phase

    You don't have to have a conversion in your proc to get errors like this. It could be a dirty data issue. Or, worse, a mis-mapped column.

    This gets 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: Can I tune this?

    Back to this project...

    Okay, I appear to be stuck on what I can do to the underlying tables (read - not much), but those links are helping me understand a...

    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: Reg: MCTS EXAM 70-445

    Raunak Jhawar (2/15/2011)


    joydeep.das.mail (2/15/2011)


    I need 70-445 brain dumps

    Joydeep, dumps will only help you get a certificate on paper.Period.What next??

    That's assuming the dumps are even close to accurate. Most dumps tend...

    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?

    Denial.

    You've heard the rumors, you've quoted the saying. Now, learn the truth. Is Denial just a river in Egypt? Or is there more to this story than the participants...

    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?

    Grant Fritchey (2/17/2011)


    jcrawf02 (2/17/2011)


    Brandie Tarvin (2/17/2011)


    Koen Verbeeck (2/17/2011)


    Gianluca Sartori (2/17/2011)


    Code brings more (pseudo)code, it seems...

    Definitely kill the one who started this on THE THREAD!

    :-D:-D

    I'll go fetch the angry mob! 🙂

    I'll...

    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?

    I rarely blog about technical stuff, mostly about writing. Today, I blogged about SQL Server and fragmentation. (It's a rephrase of something I just posted in another thread).

    If anyone 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: installation location for mdf, ldf, backup files

    I should point out that some people don't recommend defraggin SAN drives (for some very interesting reasons). Check out this link before doing any defragging:

    http://www.las-solanas.com/storage_virtualization/san_volume_defragmentation.php

    EDIT: Sjeff, I just realized you're...

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


    Gianluca Sartori (2/17/2011)


    Code brings more (pseudo)code, it seems...

    Definitely kill the one who started this on THE THREAD!

    :-D:-D

    I'll go fetch the angry mob! 🙂

    I'll supply the torches! (Who's responsible...

    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,421 through 6,435 (of 9,715 total)