Forum Replies Created

Viewing 15 posts - 6,046 through 6,060 (of 22,211 total)

  • RE: Can I change how TSQL evaluates values in SELECT statement?

    Not that I'm aware of. If I try to use code in that fashion it generates an error. You could substitute a local variable or hard code a value, but...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/20/2015)


    Grant Fritchey (5/20/2015)


    Jason A. Long (5/20/2015)


    Brandie Tarvin (5/20/2015)


    Grant Fritchey (5/20/2015)


    Again...

    AAARRARARRGGGGHHHH!!!

    Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of...

  • RE: SQL 2012 table read performance

    Tom_Sacramento (5/20/2015)


    Hi Grant - I should rephrase my statement - the book has been very helpful and elucidating - just could not correlate this scenario with the book so I...

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (5/20/2015)


    GilaMonster (5/20/2015)


    Eirikur Eiriksson (5/20/2015)


    Grant Fritchey (5/20/2015)


    AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!

    I could see this one coming miles away, surprised how long it took.

    😎

    If it's the one I'm thinking of, I hit that...

  • RE: Are the posted questions getting worse?

    GilaMonster (5/20/2015)


    Grant Fritchey (5/20/2015)


    Again...

    AAARRARARRGGGGHHHH!!!

    Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things...

  • RE: Are the posted questions getting worse?

    Jason A. Long (5/20/2015)


    Brandie Tarvin (5/20/2015)


    Grant Fritchey (5/20/2015)


    Again...

    AAARRARARRGGGGHHHH!!!

    Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a...

  • RE: SQL 2012 table read performance

    SELECT TOP 10 without any kind of ORDER BY or WHERE clause? If so, that's going to result in an index scan. That could be the issue right there. Having...

  • RE: Help fro interview question

    Can you clarify at all what you mean by "real time"?

    That doesn't define much in general within SQL Server. All the SELECT queries are run "in real time" in that...

  • RE: Are the posted questions getting worse?

    Again...

    AAARRARARRGGGGHHHH!!!

    Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things are a little...

  • RE: Sql server random slow query

    mdsantos (5/20/2015)


    The Hint FORCESEEK, seems to do the trick.

    Analysing the "bad" execution plan, I notice that the searches where done with index scan instead of index seek, incresing drastically the...

  • RE: SQL Server 2012 - High Memory Usage

    audiocool (5/20/2015)


    Hi Grant,

    I will compiled the results you are looking for tomorrow.

    Thanks.

    Sure thing. Trying hard to help out.

  • RE: Need Ammunition for Developers Doing Select *'s

    Ed Wagner (5/20/2015)


    Grant Fritchey (5/20/2015)


    Ed Wagner (5/20/2015)


    Also, be aware that this is a cultural battle that you're going to fighting, so it won't be a simple one.

    I agree...

  • RE: uninstall

    The documentation is part of the command line install documentation. You can. You just have to specifiy uininstall and the services that you have installed as well as the instance...

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/20/2015)


    Brandie Tarvin (5/20/2015)


    Grant Fritchey (5/20/2015)


    AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!

    Dare we ask?

    How about a link? You're normally so patient that it ought to be good. 😛

    We've been beating this person about the...

  • RE: Need Ammunition for Developers Doing Select *'s

    Ed Wagner (5/20/2015)


    Also, be aware that this is a cultural battle that you're going to fighting, so it won't be a simple one.

    I agree with everything you said,...

Viewing 15 posts - 6,046 through 6,060 (of 22,211 total)