Forum Replies Created

Viewing 15 posts - 17,191 through 17,205 (of 22,206 total)

  • RE: Are the posted questions getting worse?

    Paul White (6/14/2009)


    RBarryYoung (6/14/2009)


    What shall we name it? 😛

    Troll Name Generator

    Oh. Mine is rather dull: Smelly Armpit Troll

    I'm sure, with a bit of effort, I could be worth...

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/14/2009)


    Grant Fritchey (6/14/2009)


    I've got a spotlight and an alternate in the regular sessions.

    "Regular Sessions"? Are you talking about "general" sessions? I've not received anything one way...

  • RE: Are the posted questions getting worse?

    GilaMonster (6/14/2009)


    Grant Fritchey (6/14/2009)


    Jeff Moden (6/12/2009)


    I just saw the PASS session list. Congrats Gail and Grant!!!

    Congrats to Gail and thanks.

    I've got a spotlight and an alternate in the regular...

  • RE: Are the posted questions getting worse?

    GilaMonster (6/14/2009)


    Encountering that kinda attitude either in posts, PMs or emails makes me stop and ask myself why the hell I'm doing the forum thing in the first place.

    I'd answer...

  • RE: Are the posted questions getting worse?

    GilaMonster (6/13/2009)


    In all honesty, I couldn't care less. That type of attitude and replies makes me want to walk away and stop...

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/12/2009)


    I just saw the PASS session list. Congrats Gail and Grant!!!

    Congrats to Gail and thanks.

    I've got a spotlight and an alternate in the regular sessions.

    It should be...

  • RE: Lost Data! Can I query for what happened?

    For recent commands that are likely still in cache, you can query cache directly through the dmv's

    Running a query against sys.dm_exec_sql_text will let you search for delete statements or procedures....

  • RE: Max DOP

    RBarryYoung (6/12/2009)


    Actually, MAXDOP = 1 is the Microsoft recommended setting for OLTP environments, especially heavily loaded ones.

    Hey Barry, If you start working with spatial data in 2008, you may find...

  • RE: Are the posted questions getting worse?

    Roy Ernest (6/12/2009)


    I am married... She points out my mistakes when I am home... :hehe:

    Grant, Steve Thanks for the input. The Parameter size that is passed through with variable size,...

  • RE: Max DOP

    simsr (6/12/2009)


    What you're seeing is an artifact of the estimated cost values. SQL Server can't know how long a query is going to take to run, so the estimated cost...

  • RE: Are the posted questions getting worse?

    Roy Ernest (6/12/2009)


    What do you all know about nHibernate? Seems like it has a problem executing SPs. They are good for CRUD I guess.

    Isnt Subsonic better than nHibernate? Subsonic...

  • RE: Joins

    Sounds like you need a LEFT join. That will return all from A and only those that match from B.

  • RE: Max DOP

    simsr (6/12/2009)


    Interesting - I just went through this same process myself last week, but I did it a little differently becuase I was concerned about the same thing. Instead of...

  • RE: Reindexing a table with scan density 99%

    Hard to know for sure, but hazarding a guess, your index was defragged, but the statistics were out of date, so rebuilding the index updated the statistics which fixed the...

  • RE: Query seems very slow for what its doing

    This part of the code is going to cause problems:

    WHERE

    p.RegionID = COALESCE(@RegionID, p.RegionID)

    AND

    p.PriceBracketID = COALESCE(@PriceBracketID, p.PriceBracketID)

    If you get index use ata ll on this table,...

Viewing 15 posts - 17,191 through 17,205 (of 22,206 total)