Forum Replies Created

Viewing 15 posts - 6,931 through 6,945 (of 9,715 total)

  • RE: Today's Random Word!

    CirquedeSQLeil (12/1/2010)

    Brandie Tarvin (12/1/2010)

    Certifiable.

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

    Yes I am - woohoo :hehe::satisfied::alien:

    The proper response is "I know you are, but what am I?" :w00t:

    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 2, 2010 at 10:48 am

    #1258012

  • RE: My report doesn't show data!

    artan_p (12/2/2010)

    Hi!

    In my project I have used Qureis, maybe I must use procedures

    Could it be my problem!?

    We're not going to even try to answer that question until you tell us...

    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 2, 2010 at 8:51 am

    #1257937

  • RE: Are the posted questions getting worse?

    Can anyone point me to a good example of an abstract that was submitted for PASS? A weblink or something?

    I want to apply as a speaker for SQL Rally and...

    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 2, 2010 at 7:32 am

    #1257884

  • RE: My report doesn't show data!

    It sounds like either a network issue or a permissions issue. If you're not willing to look at Craig's questions and test them out for yourself to verify none of...

    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 2, 2010 at 5:58 am

    #1257816

  • RE: Today's Random Word!

    Tea

    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 2, 2010 at 5:50 am

    #1257811

  • 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

Viewing 15 posts - 6,931 through 6,945 (of 9,715 total)