Forum Replies Created

Viewing 15 posts - 6,976 through 6,990 (of 9,399 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/15/2014)


    We're still tuning stuff.

    believe me, it's as much a pain for me as anyone else.

    Steve, let me know if you'd like help with any...

  • RE: Are the posted questions getting worse?

    spaghettidba (11/17/2014)


    During the weekend the spam rate was so high that it came in faster than I could report it.

    Some things come to my mind:

    1) Isn't there a captcha for...

  • RE: can you have too many rows in a table

    Jeff Moden (11/15/2014)


    Thanks for the plug, Ed! 🙂

    No problem. You've earned it - it's a great presentation that delves into how it really works. The dust bunnies must...

  • RE: It's Not Just Poor Coding

    I particularly like the point Steve makes about email. Companies put security policies and technical controls in place, then employees inundate each other with loads of email and attachments....

  • RE: It's Not Just Poor Coding

    Steve Jones - SSC Editor (11/13/2014)


    Meow Now (11/13/2014)


    Security is expensive. More so in time than actual monetary costs. My company is pretty well locked down (Healthcare data)...even the usb and...

  • RE: Should I create an SP

    In either approach, the code will generate two plans - one for each statement. I think what Jeff was referring to it the staging database not having to log...

  • RE: FTP on SQL Server

    We have a configuration where our SQL Server reads files that were FTPed to us. We have them on separate servers and I'd recommend the same thing to you....

  • RE: Column content is truncated when I view but there when I process

    There are also buttons on the SQL Editor toolbar in SSMS that allow you to write the results to text, grid or file. I think the chances are probably...

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/14/2014)


    Help! The spam invasion returned. I feel like I'm drowning.

    It comes in waves. Steve posted something about a week ago that there was a performance issue with...

  • RE: can you have too many rows in a table

    Jeff Moden (11/14/2014)


    And, yeah... I'm in the process of setting up temporal partitioning with read only files that never need to be backed up again and I'll be able to...

  • RE: Scalability Question

    I think I'd first verify the sanity of the question, then combine the shock of Michael's #1 and the logic of #2:

    You've got to be kidding me. The design...

  • RE: Today's Random Word!

    djj (11/14/2014)


    Ed Wagner (11/14/2014)


    SQLRNNR (11/14/2014)


    Ed Wagner (11/14/2014)


    Stuart Davies (11/14/2014)


    Ed Wagner (11/14/2014)


    Friday

    Crunchie

    Texture

    Putty

    Silly

    Fool

    Inexperience

  • RE: can you have too many rows in a table

    It depends completely on the structure of the table. Like Erikur said, duplication can be normalized to eliminate it.

  • RE: Today's Random Word!

    SQLRNNR (11/14/2014)


    Ed Wagner (11/14/2014)


    Stuart Davies (11/14/2014)


    Ed Wagner (11/14/2014)


    Friday

    Crunchie

    Texture

    Putty

    Silly

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    GilaMonster (11/14/2014)


    Jason-299789 (11/14/2014)


    Gail/Lynn/Ed,

    I don't disagree, and as Lynn states maybe if MS enforced it so that code wouldn't compile without the use of the statement terminators, like they do in...

Viewing 15 posts - 6,976 through 6,990 (of 9,399 total)