Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 3,604 total)

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

  • RE: How to pronounce SQL

    You should see the Russian for "restaurant". It can be rendered as "ÐÅÑÒÎÐÀÍ" in standard font but looks rather more complex in cyrillic. To add to the confusion...

  • RE: Use Backup to Copy a DB

    It takes a special sort of genius to name a function so that is so short it qualifies for a noise word in search engines!

    I can't see that anyone...

  • RE: Use Backup to Copy a DB

    What exactly does N'string' do? Is it really necessary?

Viewing 15 posts - 3,436 through 3,450 (of 3,604 total)