Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: Is a Blogger a Journalist?

    The western coalition invaded Iraq is a fact, it does rather require interpretation!

    edit - add better eg.

    It is also a fact that rebuilding indexes can aid performance. It...

  • RE: Is a Blogger a Journalist?

    I'm not going to go into the first amendment thing, because its US Centric and so irrelevant for me. It is of course, highly relevant, for americans.

    I agree that...

  • RE: Optimizing Cursor Performance

    I realize that there is an implied authority there. I hate it, in fact I probably would use the words false advertising 'officially authorized Oracle Press' does not suggest to...

  • RE: Optimizing Cursor Performance

    No worries, I didn't think you were bagging Oracle. It was more a marketing thing for me. neither the sybex books - nor, more particularly, the Oracle Press books have anything...

  • RE: Optimizing Cursor Performance

    I'm not entirely sure what books you refer to. Certainly both the VP of Server technologies and the docs have suggested that one would naturally prefer set based methods to...

  • RE: Optimizing Cursor Performance

    Nice article, I must admit I was drawn in by the description on the front page which reads <quote> Since SQL Server 2000 is optimized to run with set based...

  • RE: Question of the Day for 10 Sep 2004

    I'm not especially impressed by the suggestion that

    IF EXISTS( SELECT 1 FROM #mytable) PRINT 'Already created'

    is incorrect since it will print an error message if the table doesn't...

  • RE: Where Do I Want To Go Today? - Lossless Performance

    Being someone who runs both Oracle and SQLServer, I couldn't help but smile at the comment "The current method of setting up profiler looks like something from Oracle, some cumbersome,...

  • RE: Using Different Techniques for SQL Server Automation

    Small comment.

    I really don't like On Error Resume next in any code - I know vbscripts error handling is poor in the extreme, but I'd write any errors to...

  • RE: SQL Server Security: The db_executor Role

    I'd also add to the comments about production and use of change management procedures. I'd never allow a procedure that automatically granted changed permissions to users to run in production...

Viewing 10 posts - 1 through 10 (of 10 total)