Post reply

Preventing recompile

  • October 13, 2014 at 8:10 pm

    #74261

    Comments posted to this topic are about the item Preventing recompile

  • October 13, 2014 at 8:56 pm

    #1752110

    🙂 Good One Steve 🙂

  • October 14, 2014 at 1:04 am

    #1752123

    An easy one, thanks Steve.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 14, 2014 at 4:15 am

    This was removed by the editor as SPAM

  • October 14, 2014 at 5:09 am

    #1752165

    Another question where I got to learn something. Thanks. I haven't gotten to play with 2014 yet, but still enjoy learning about it. Perhaps someday, but it won't be for a while yet, I'm sure.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 14, 2014 at 6:48 am

    #1752193

    Good Question, learned something...

  • October 14, 2014 at 7:22 am

    #1752206

    Stewart "Arturius" Campbell (10/14/2014)

    Good one, thanks Steve

    I prefer to avoid using query hints, only using them where absolutely necessary, and then only after serious thought...

    The best practice, IMHO.

  • October 14, 2014 at 7:31 am

    #1752211

    Ed Wagner (10/14/2014)

    Another question where I got to learn something. Thanks. I haven't gotten to play with 2014 yet, but still enjoy learning about it. Perhaps someday, but it won't be for a while yet, I'm sure.

    +1 Thanks for the question Steve.


    Everything is awesome!

  • October 14, 2014 at 7:37 am

    #1752217

    Nice question. Thanks for sharing

  • October 14, 2014 at 9:34 am

    #1752247

    Dana Medley (10/14/2014)

    Ed Wagner (10/14/2014)

    Another question where I got to learn something. Thanks. I haven't gotten to play with 2014 yet, but still enjoy learning about it. Perhaps someday, but it won't be for a while yet, I'm sure.

    +1 Thanks for the question Steve.

    +1

    Thank you for the post, Steve, very new one to me.

    (I am playing with 2014 theoretically using the local_help, it has enough material to keep me busy for the rest of my life.)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • October 14, 2014 at 2:00 pm

    #1752313

    What's a scenario where it would make sense to use this?

  • October 14, 2014 at 11:05 pm

    #1752376

    Learnt something new today, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • October 15, 2014 at 7:32 am

    #1752526

    Nice question - the fourth option is an amusing trap, but it didn't cTHIS IS CLEARLY SPAM.

    Don't much like query hints, because they are an opportunity for the typical de-optimizer (aka arrogant DBA or Developer) to overrule the optimizer.

    Tom

  • October 15, 2014 at 8:40 am

    #1752566

    marcia.j.wilson (10/14/2014)

    What's a scenario where it would make sense to use this?

    Probably somewhere that is giving you bad plans or sniffing, and you want to freeze things when you get one. However, I would try to avoid it as it becomes a point of maintenance and if things change, you might wonder why you get stranger things happening.

  • October 21, 2014 at 7:06 am

    #1753721

    Stewart "Arturius" Campbell (10/14/2014)

    Good one, thanks Steve

    I prefer to avoid using query hints, only using them where absolutely necessary, and then only after serious thought...

    I agree about the query hints. For some reason I believe (in general) the system is smarter than me and can figure it out without my giving it a hint.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply