Forum Replies Created

Viewing 15 posts - 6,946 through 6,960 (of 9,720 total)

  • RE: Weird query plan

    Maybe I'm off base here, but could the scan be caused by SQL Server pulling the data and then checking the permissions for each record to see if the user...

    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.

    December 1, 2010 at 11:01 am

    #1257515

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    James Stephens (12/1/2010)

    My original beef with isNumeric() was the single characters that returned 1. For example, a dot is not a number. Period. It's not "numeric". ...

    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.

    December 1, 2010 at 10:50 am

    #1257509

  • RE: Weird query plan

    Maybe you have the plans misnamed, but "Without_repl_predicates" shows an Index scan (IndexScan Ordered="true") and the other plan shows the opposite??

    Anyway, while I'm playing with this, try doing the first...

    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.

    December 1, 2010 at 8:53 am

    #1257446

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (12/1/2010)

    Brandie Tarvin (12/1/2010)

    Greg Edwards-268690 (12/1/2010)

    For the data warehouse - are you implying slowly changing dimensions?

    Although the 3 tables wouldn't seem necessary.

    There are no really good standards for 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.

    December 1, 2010 at 8:45 am

    #1257433

  • RE: Weird query plan

    Gianluca Sartori (12/1/2010)

    None of these predicates need to access the tables, so why a scan?

    Because you've got them all lumped together??? To my eyes, the code should say:

    ...

    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.

    December 1, 2010 at 8:28 am

    #1257407

  • RE: Weird query plan

    Gianluca Sartori (12/1/2010)

    How can

    AND ({fn ISPALUSER('23320088-BB3F-46AC-905D-0F2A95181934')} = 1

    ...

    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.

    December 1, 2010 at 8:15 am

    #1257392

  • RE: Weird query plan

    I don't see ISPALUSER in BOL. Can you script that function out for me?

    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.

    December 1, 2010 at 8:13 am

    #1257388

  • RE: Are the posted questions getting worse?

    GSquared (12/1/2010)

    Which reminds me. Jack, I work in Orlando now. Let me know if you want me to present anything to your group again this winter. Was...

    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.

    December 1, 2010 at 6:54 am

    #1257318

  • RE: Are the posted questions getting worse?

    GilaMonster (12/1/2010)

    Brandie Tarvin (12/1/2010)

    This is the time to ask for a raise, methinks.

    Ask? What is this ask? I'm a consultant. "As of Jan 1st, the new hourly rate will be...

    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.

    December 1, 2010 at 6:33 am

    #1257300

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (12/1/2010)

    For the data warehouse - are you implying slowly changing dimensions?

    Although the 3 tables wouldn't seem necessary.

    Yes and no. The way that slowly changing dimensions are implemented 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.

    December 1, 2010 at 6:31 am

    #1257298

  • RE: Are the posted questions getting worse?

    GilaMonster (12/1/2010)

    You know there's a problem when...

    In the last 2 weeks there have been three resignations at current client:

    The senior developer (leaving only 2 permanent developers)

    The Chief Enterprise...

    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.

    December 1, 2010 at 6:18 am

    #1257288

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    svetlana.davkovska (12/1/2010)

    This function is OK for integer numbers, what about decimal or negative ?

    I'm not sure I understand your question.

    If you test it, ISNUMERIC() will come out as true 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.

    December 1, 2010 at 6:01 am

    #1257274

  • RE: Are the posted questions getting worse?

    Tom.Thomson (12/1/2010)

    CirquedeSQLeil (11/30/2010)

    For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].

    The 744 pixel wide image doesn't really fit well unscaled in a 670...

    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.

    December 1, 2010 at 5:15 am

    #1257249

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Even people who think they know should read this article. I actually knew all about the punctuation and currency signs, but then I got to the "e" and "d" part....

    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.

    December 1, 2010 at 4:50 am

    #1257239

  • RE: Today's Random Word!

    lemon

    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.

    December 1, 2010 at 4:45 am

    #1257234

Viewing 15 posts - 6,946 through 6,960 (of 9,720 total)