Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 3,652 total)

  • RE: DB2 A Worthy Competitor?

    The tools thing with JAVA was interesting. I've used a CMS called MediaSurface where the interface is all JAVA based.

    The controls are highlighted but don't have focus until you...

  • RE: Other databases

    My first job was with a company that had just taken delivery of an HP3000/42. It had a disk drive the size of a large domestic washing machine and...

  • RE: How to pronounce SQL

    Obviously America is the king of the acronymn world. I seem to remember that one of the US Navy commander in chiefs has an acronymn for his title of...

  • RE: Thanks for taking the test!

    Having had a quick read around the C2 auditing subject (and deciding that it is massive overkill) does this imply that the default data location for SQL should be left...

  • RE: Thanks for taking the test!

    The newsletter looks different enough to be fresh without being different enough to be unfamiliary.

    My only questions would be

    • Have you got enough coming in for a daily newsletter?
    • Are you...
  • RE: How to pronounce SQL

    quote:


    Why was it called Port and Starboard? Does the ship only sail one way, keep the stars on the left(?)


  • RE: How to keep and restore the deleted records?

    I prefer to use a deleted date field that acts as a flag in the critical tables.

    This means that I can also identify when a record was deleted. When...

  • RE: Thanks for taking the test!

    quote:


    I enjoyed it but the answer about changing the SQL Login has me confused.

    The answer says use an UPDATE query on the...

  • RE: Thanks for taking the test!

    I enjoyed it but the answer about changing the SQL Login has me confused.

    The answer says use an UPDATE query on the SysLogins table and then also says manual updates...

  • RE: Nesting Stored Procedures

    Robert,

    I don't have the specific example to hand as its in an archived project library.

    From what I remember I wrote code to produce a paginated list of records from a...

  • RE: Nesting Stored Procedures

    How many users? In excess of 30,000.

    What you could do is write your GUI so that your main user interface is in a bald HTML file and that file is...

  • RE: Nesting Stored Procedures

    I take it that you are talking about a web application?

    I have found that tasks that are too small to affect the performance of normal apps become massive overheads on...

  • RE: Nesting Stored Procedures

    I use nested stored procedures for the same reasons.

    I quite often have

     
    
    IF .....
    INSERT #Tbl (Fields)
    EXEC usp_SelectProc1 @Arg1, Arg2...Argn
    ELSE
    ...
  • RE: How to pronounce SQL

    quote:


    Or, as I once heard "Squeeel"


    This is how it's pronounced if you're a finance director...

  • RE: SQL Server and JDBC

    I had a huge document on performance characteristics of ORACLE, SQL Server, MySQL, DB2 and one or two others that included JDBC performance.

    I thought it was on http://www.mysql.com but I...

Viewing 15 posts - 3,481 through 3,495 (of 3,652 total)