Forum Replies Created

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

  • Reply To: Using a Surrogate vs Natural Key

    It often occurs that we need to collect partial information to be completed later in a subsequent step when it becomes available. Haven't we all stood in line behind someone...

  • RE: Refactoring SQL Server code

    Refactoring, at least as used by the defacto canonical book "Refactoring" by Martin Fowler, doesn't mean simply altering code, whether to good effect or not, whether well-written or not.

    It's explicitly...

  • RE: Re-compilation and Its effects on Performance

    There is value in being aware of the many reasons queries are fast or slow. What would begin making this useful would be a. A discussion about relative magnitude of...

  • RE: Writing Nearly Codeless Apps: Part 4

    To repeat what others have said, this has been done over and over.

    The thing that makes me most nervous though is how it turns the user

    interface into a big table...

  • RE: Row Oriented Security Using Triggers

    Glen Cooper (4/27/2010)


    The model was originally developed for a Citrix farm, where the front-end apps aren't available on anyone's desktop and where users aren't able to see behind the data...

  • RE: Row Oriented Security Using Triggers

    Did I understand that you have Administrators writing rules that are passed through triggers? Given the inherent difficulty of debugging triggers isn't that an issue?

    Don't you have an issue where...

  • RE: The Dynamic Tally or Numbers Table

    As to the size of the table, you'll presumably write it to be large enough for the purpose to which you are applying it at the time. Validating its size...

  • RE: The Dynamic Tally or Numbers Table

    It still seems to me like a solution in search of a problem.

    If you can't get a simple static table approved for a

    perfectly defensible purpose, why would The Force...

  • RE: Performance Effects of NOCOUNT

    Cliff Jones (12/7/2007)


    I couldn't agree with you more. I have always wondered why the double negative. Didn't we all learn that in programming 101. And WHY is...

  • RE: Performance Effects of NOCOUNT

    I've always wondered why SET NOCOUNT ON has not been the default. It seems self-evident that doing more work takes longer, and should be made optional. Basically, don't do the...

  • RE: Cursor for update result in loop...

    Ordinarily one uses cursors for normal database activity as a last resort. Hopefully you can simplify this a bit.

    Can you describe what you are trying to accomplish at a little...

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