Forum Replies Created

Viewing 15 posts - 16,741 through 16,755 (of 22,213 total)

  • RE: Sin City SQL

    This will be my first time in Vegas too. I'm not crazy about gambling, but I understand other forms of entertainment are available. I'll spend most of my time at...

  • RE: Are the posted questions getting worse?

    Kit G (8/12/2009)


    Grant Fritchey (8/12/2009)


    I'm pretty sure they are. There was a new printing of The Moon is a Harsh Mistress just recently. I'm rereading Farnums Freehold on my Kindle...

  • RE: Are the posted questions getting worse?

    Kit G (8/11/2009)


    Bob Hovious (8/11/2009)


    Maybe one day there will be a remake that gets it right.

    Well, the remake might get the specials correct (the bugs, suits and...

  • RE: Are the posted questions getting worse?

    I am not witty, but here's my pass:

    No Longer Single Double

  • RE: Are the posted questions getting worse?

    GilaMonster (8/10/2009)


    Chad Crawford (8/10/2009)


    I don't think any of you have to worry about too much. English is my first and pretty much only language, but I still don't dare...

  • RE: Twenty tips to write a good stored procedure

    I do want to raise one point that was mentioned earlier. In 130 or so comments, where is the author? I think he put forward an honest best faith effort...

  • RE: Twenty tips to write a good stored procedure

    GilaMonster (8/10/2009)


    timothyawiseman (8/10/2009)


    I am not clear on if temp tables generate better execution plans than table variables. I have not formally tested it, but intuitively I would expect the...

  • RE: Twenty tips to write a good stored procedure

    timothyawiseman (8/10/2009)


    GSquared (8/10/2009)


    Have to sort of disagree with you on this one. Temp tables cause statement recompiles in 2005/8, and proc recompiles in 2000, but even those are often/usually...

  • RE: Are the posted questions getting worse?

    GilaMonster (8/10/2009)


    Grant Fritchey (8/10/2009)


    In my haste I even missed things, like using a WHILE loop as a cure for cursors... when will that die?

    Well, they are a cure for cursors....

  • RE: Speed Optimization

    I agree with Paul. Split up the machine and you should be good to go. However, it's worth noting, the "good" instance might not be quite so good any more.

  • RE: Are the posted questions getting worse?

    It was a good faith effort, but based on the "Oh boy, I gave this 5 stars, my life is better" responses that were in the discussion in a few...

  • RE: Twenty tips to write a good stored procedure

    I saw Gail's answers and I think she hit the ones I was going to hit, but I'm feeling the need to pile on a bit.

    #8: KEEPFIXED PLAN can...

  • RE: Query Question

    That's tough. But in terms of performance, you could still use a TOP with an ORDER BY and arrive at one row, if somewhat randomly. It usually performs better,...

  • RE: Losing my primary keys!

    Well, it's possible, if you're backing up to the same place every time, that your backups are aggregating within a single file. If so, when you run a restore, you...

  • RE: Script to moniotr dead locks

    Agent alerts is the easy way. Why have something polling the server when it's already built in.

Viewing 15 posts - 16,741 through 16,755 (of 22,213 total)