Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 6,486 total)

  • RE: How to show and HTML and XML code?

    Steve Jones - Editor (3/15/2008)


    Like this?

    <name>

    I've used the [ code ] [ / code ] tags from the shortlist for the code and then the "& l t ;" and...

  • RE: More RBAR and "Tuning" UPDATEs

    Jeff Moden (3/15/2008)


    Compare that to where C/C++ programmers have been for over 15 years: they can write new code targeted to run on multiple different platforms right from the start...

  • RE: How to fill the record for missing month

    tosscrosby (3/14/2008)


    Jeff, Checked out your article and besides complimenting you on it, I have a question..how did you get this article into the future? Is that another of your many...

  • RE: SQL Server Failover clustering Licensing

    One interesting thing is - I can't find that wording anywhere else. The current EULA mentions no 30-day limit, and neither does the How to buy document...

  • RE: SQL Server Failover clustering Licensing

    That's actually a good question. Every time I've asked the question to a licensing specialist - I've received essentially the answer Philip mentioned (if your primary server is "dead"...

  • RE: Trouble writhing the code for a new trigger

    Tom Garth (3/14/2008)


    Keep in mind that if just 1 row meets your criteria, you will be undoing the entire update.

    Along those lines - if you want the "valid" ones to...

  • RE: Copy one row from any table to same table

    Try updating the column list build to put brackets around the column names. You never can tell when you might run up against a "reserved word" used as a...

  • RE: Updating SQL Server Tables via .aspx built with VWD Not Working

    Your parameters got "whacked" when you pasted it. You need to paste them into a text editor and run a search and replace for the brackets.

    Replace < with &lt;

    Replace...

  • RE: More RBAR and "Tuning" UPDATEs

    (fixed the tag - thanks).

    It's a fair position to start from. I have spent a lot of time supporting and developing in what I will call "hardware crippled" environments,...

  • RE: sql2000 transaction log keeps filling up

    Have you tried simply issuing a "checkpoint" command? See if it just needs to be reminded to move along?

  • RE: Performance Question

    jamiejulius (3/13/2008)


    Thanks for the comment. Actually I think it helps very much since I'm only asking for the first record which matches.

    If the index is being used - that's great....

  • RE: More RBAR and "Tuning" UPDATEs

    Hugo Kornelis (3/14/2008)


    Matt Miller (3/14/2008)


    And there are other folks who don't know that what you call Oracle syntax is actually ANSI-standard syntax, and that the optional FROM clause in SQL...

  • RE: TRY/CATCH not working as expected

    I can't help but think that somehow it's happening in a different context, or that somehow it's raising an error on the "wrong server". There are a few of...

  • RE: More RBAR and "Tuning" UPDATEs

    And there are other folks who don't know that what you call Oracle syntax is actually ANSI-standard syntax, and that the optional FROM clause in SQL Server is non-standard. In...

  • RE: More RBAR and "Tuning" UPDATEs

    Manie Verster (3/14/2008)


    :P:P Excellent article Jeff, I have a question for you though. Is there a FROM clause for the DELETE statement as well and how can I code that?:w00t:

    Manie...

Viewing 15 posts - 4,141 through 4,155 (of 6,486 total)