Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 3,518 total)

  • RE: Other databases

    quote:


    I may be showing my age, but anybody ever hear of an old product called Alpha 3 which later became Alpha 4?...

  • RE: PM's/Management Vs DBAs

    We Brits have this thing called Snakebite (Lager and Cider mixed). Its magic, it makes all members of the opposite sex devastatingly attractive whilst simultaneously turning you into superman.

    I...

  • 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
    ...

Viewing 15 posts - 3,346 through 3,360 (of 3,518 total)