Forum Replies Created

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

  • RE: Today's Random Word!

    Certifiable.

    Yeah. Couldn't resist that one. @=)

    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 12:44 pm

    #1257575

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

    JRUDE (12/1/2010)

    My apologies. I had not read through all of the responses prior to posting my reply. Your explanation was very clear. Thank you for being kind.

    No...

    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 12:33 pm

    #1257566

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

    Stefan Krzywicki (12/1/2010)

    The LIKE '%[0-9]%' will return any string that has any number in it anywhere.

    The NOT LIKE '%[^0-9]%' will return any string that has only numbers in it.

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

    December 1, 2010 at 12:32 pm

    #1257564

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

    JRUDE (12/1/2010)

    Perhaps I'm missing something, but doesn't the following do the same thing in a more straightforward way (without the double negatives)?

    somecolumn like '%[0-9]%'

    Go back and re-read the last two...

    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 12:25 pm

    #1257555

  • RE: Today's Random Word!

    We are feasting today upon Lemon Sponge Cake with Lemon frosting (as in lemon flavored frosting).

    Scrumptious.

    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:04 am

    #1257517

  • 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

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