Forum Replies Created

Viewing 15 posts - 5,836 through 5,850 (of 9,643 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/25/2009)


    Bob Hovious (2/25/2009)


    Hey G 🙂

    It's not barrier to entry. Nobody has to take a test on the material. It's just something that...

  • RE: Are the posted questions getting worse?

    Bob Hovious (2/25/2009)


    (Forgive me Lynn, but in the past year I've begun to put commas at the FRONT of lines when listing columns.)

    Heretic!:D

    P.S. That IS sarcasm

  • RE: Are the posted questions getting worse?

    Max (2/25/2009)


    Welcome to megalomaniacs central, folks!

    Don't bother us with your petty sql statements, do not ask us questions without reading the dozen or so best practice documents; blogs and forums...

  • RE: Are the posted questions getting worse?

    GilaMonster (2/25/2009)


    Lynn Pettis (2/25/2009)


    What is "best practices" actually? What is "best" today may not be "best" a week, or month, or year from now.

    Which is one of the reasons...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/25/2009)


    How true. PeopleSofts tools create poorly formatted SQL code. If I need to review that code, the first thing I have to do is reformat it...

  • RE: How to write efficient stored procedure ?

    David McKinney (2/25/2009)


    Jack Corbett (2/24/2009)


    Jack, Is your @page_Id not going to be null if the IF returns FALSE?

    That's why that is just a starting point 😀

    Really an oversight on my...

  • RE: Interesting Deadlock Graph with one lock

    Could be. You should look at the direct XML representation of the graph.

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/25/2009)


    As I do use a case-sensitive collation, it forces me to be consistant with naming of variables, tables, columns, etc.

    Okay, so I have to be honest and say...

  • RE: Timeout Issues

    I would definitely recommend to the client that they start preparing to apply the service packs as there are several security related issues that are addressed by the service packs....

  • RE: Timeout Issues

    According to this article[/url] that is the RTM version. You may want to start looking at service packs since there are 3 available and this may have been a...

  • RE: Interesting Deadlock Graph with one lock

    Amazingly enough I just read a series of blog posts by Bart Duncan that addresses this situation. Here is a link to the first post in the series as...

  • RE: Are the posted questions getting worse?

    I would venture to guess that the majority of the posters on this thread would be folks that use schema qualification and aliases all the time.

    I know I try...

  • RE: Timeout Issues

    According to BOL 0 is a valid value for the timeout property and is the default value. Here is a quote from BOL:

    TimeOut

    Specify the maximum number of seconds...

  • RE: problem send email with-xp_SMTPSendMail-result of a query

    In my opinion, you should be migrating away from xp_smtpsendmail in your SQL Server 2005 install as Database Mail using SMTP and also is now asynchronous through it's use of...

  • RE: Production security for developers - 'emergency' updates

    When you say Update authority, do you mean the ability to update data or do you mean Alter [object] authority? There is a difference. If it is to...

Viewing 15 posts - 5,836 through 5,850 (of 9,643 total)