Forum Replies Created

Viewing 15 posts - 16 through 30 (of 81 total)

  • RE: Keeping my cardinality

    PHYData DBA (4/29/2014)


    paul.goldstraw (4/29/2014)


    PHYData DBA (4/29/2014)


    shanjan.sapra (4/29/2014)


    Nice question. But I guess the another answer is also true as an Another alternative to enable/disable the different CE algorithms is the usage...

  • RE: Keeping my cardinality

    PHYData DBA (4/29/2014)


    shanjan.sapra (4/29/2014)


    Nice question. But I guess the another answer is also true as an Another alternative to enable/disable the different CE algorithms is the usage of a trace...

  • RE: Keeping my cardinality

    Yep, it left a bit to the imagination. Sadly I imagined wrong. If In-Memory wasn't relevant it really shouldn't have been mentioned because the question came across like it was...

  • RE: Keeping my cardinality

    I don't understand. I chose the last option, 'Alter all queries to use the trace flag 9481', which this page says will force use of the old version 70 optimiser....

  • RE: GO-ING nowhere

    Also if I paste either result into Notepad GO is on the same line. I had a feeling this would happen, but had no idea the engine wouldn't care for...

  • RE: Hidden Formatting Troubles with STR() (SQL Spackle)

    Thanks Jeff, makes sense. If someone asked me to right justify some text I think the quicker solution would be closer to what I would have attempted anyway as i'm...

  • RE: Hidden Formatting Troubles with STR() (SQL Spackle)

    Sorry if I'm just being dense by asking this, I've never used STR() either so this is new to me. The article says many people use STR() for its ability...

  • RE: The Case of the Lost Card

    With regard to the badges themselves, our badges used to contain the company logo etc on them, in addition to the person's name and photo. Now they just contain the...

  • RE: Natural Data

    I'm firmly on the side of this sort of thing not being being something you can patent. Patenting the means to snip, maybe. Patenting what has been snipped, no. That...

  • RE: A Quick Count

    I have none 🙁

    Feel free to send me one though 🙂

    Cheers

    Paul

  • RE: Stack Ranking

    I think it's a terrible system. This means you could have a room full of the best and brightest, all of whom would be a '5' in a random sample...

  • RE: What causes parameter sniffing to start?

    Gail,

    Thanks for elaborating on the complexities of this issue. I do appreciate any resolution that I would class as a fix would have negative side-effects as parameter sniffing is,...

  • RE: What causes parameter sniffing to start?

    Eugene Elutin (3/7/2012)


    GilaMonster (3/7/2012)


    paul.goldstraw (3/7/2012)


    However, I don't consider this, or any of the other solutions online to be true solutions. A real solution would be code that just works....

  • RE: What causes parameter sniffing to start?

    Lynn Pettis (3/6/2012)


    Just food for thought. If the procedure(s) have been working well for months (or longer) and then suddenly start having issues, it could be a result in...

  • RE: What causes parameter sniffing to start?

    Eugene Elutin (3/6/2012)


    paul.goldstraw (3/6/2012)


    ...Dynamic SQL is not an option as the industry I work in is quite security conscious, so I am not allowed to code for that

    ...

    Are you allowed...

Viewing 15 posts - 16 through 30 (of 81 total)