Forum Replies Created

Viewing 15 posts - 8,146 through 8,160 (of 8,416 total)

  • RE: Thoughts on QlikView

    Yes - I read that today, though I thought it was a bit light on specifics, it is not a bad general overview.

    Paul

  • RE: Performance issue with tally solution

    Aw, just be done with it and create your own internet!

    Flinternet? :blink:

    Paul

  • RE: Indexing Options question

    Hey Wayne,

    I hope the previous responders won't mind if I add my two cents:

    WayneS (4/28/2009)


    When we identified which queries were involved, one of the dbas pulled up the tables and...

  • RE: ASYNC_NETWORK_IO

    Hey Heather,

    If the wait time is being reset frequently as you say, and if the wait times are low (say 50 or less), the issue is most likely that the...

  • RE: Comparison of Dates in SQL

    Aneesh (4/28/2009)


    Using SQL function in where condition is not a good practice.

    So one should only use functions in SELECT statements?

    Is that your point?

    😛

    To be fair, I think your comment was...

  • RE: Performance issue with tally solution

    Adam Machanic (4/28/2009)


    Hmm, that looks a lot like a replacement for XML to me 🙂

    What's the use case?

    Optional 'attributes' of existing entities have been stored rolled up into a string...

  • RE: Performance issue with tally solution

    Flo,

    Forget the articles.

    You're looking at a book!!!

    Cheers,

    Paul

  • RE: Performance issue with tally solution

    Florian Reischl (4/28/2009)


    Hierarchical data to be split? Well. This becomes really freaky... It would require either recursive methods or a much more complex RegEx which also becomes quiet slow.Flo

    Hey Flo,

    I...

  • RE: Performance issue with tally solution

    Adam Machanic (4/28/2009)


    David Burrows (4/28/2009)


    I split data with consecutive delimiters, ie a column/field with no data

    In most of the use cases I'm interested in, "a,,b,,c" with a delimiter of ","...

  • RE: Comparison of Dates in SQL

    TheSQLGuru (4/28/2009)


    This can lead to incorrect values in SQL 2008 if the more precise datetime data types are used.

    Not just 2008 - as Lynn has correctly observed!

  • RE: Performance issue with tally solution

    @mister.magoo,

    I think the function you refer to was one I posted originally, and improved by Flo. Not that I'm territorial!

    The point about the scalability is not so much about...

  • RE: Are the posted questions getting worse?

    GilaMonster (4/28/2009)


    Set options and users, yes, different plans, however not reusable without exactly the same userID and/or set options.

    I think it is OR there, rather than AND. I don't...

  • RE: Are the posted questions getting worse?

    I posted this before as an afterthough edit, but I guess you missed it:

    In your reply to Tao Klerks in that thread, is it not true that many plans can...

  • RE: Are the posted questions getting worse?

    GilaMonster (4/28/2009)


    ...some functions can be collapsed so that the optimiser gets correct values to do it's estimates if those functions are on parameters or constants. I have no recollection offhand...

  • RE: Are the posted questions getting worse?

    Gail,

    Thanks for that detailed explanation, it is appreciated.

    GilaMonster (4/28/2009)


    Oh, and if you think that one's bad you should see the article from a week or so ago where someone seriously...

Viewing 15 posts - 8,146 through 8,160 (of 8,416 total)