Forum Replies Created

Viewing 15 posts - 1 through 15 (of 72 total)

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    L' Eomot Inversé (12/15/2011)


    Thomas-282729 (12/15/2011)


    Perhaps it would help if you defined what *isn't* "business logic" that belongs within the confines of a solution for a business. As I said earlier,...

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    L' Eomot Inversé (12/14/2011)


    Thomas-282729 (12/13/2011)


    I do not consider check constraints to be "business logic" even if it is a rule dictated by the business.

    Amazing. Rules dictated by the...

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Let's step back for a second. The point I have made multiple times is that if you have to resort to T-SQL cursors, that is logic that almost assuredly does...

  • RE: The Apprentice

    My experience has been that CS majors learn more about how compilers, sorting algorithms and computers work than how make effective use of them. The CS majors with whom I've...

  • RE: Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

    I think Hugo said it best many pages ago, but it bears repeating. For every table in which you use a surrogate key, you should also have at least one...

  • RE: Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

    JJ B (10/25/2010)


    Hugo wrote:

    And consider what so many people call a junction table - a table that represents the many-to-many relationship between two tables. I will usually model these as...

  • RE: Disk Is Cheap! ORLY?

    1) Please keep in mind that this issue is a compounded one since a field can show up in other tables as well as using memory, CPU, network, log space,...

  • RE: Disk Is Cheap! ORLY?

    If you ask your manager whether she'd rather wait 10 minutes for her answer, or 10 seconds, she's going to go for the 10 second option.

    Of course this is...

  • RE: Disk Is Cheap! ORLY?

    What is never mentioned in the article is "Scale to what point?". Let me demonstrate: You are using a bigint for a primary key on a table with a billion...

  • RE: Are There That Many GUIDs?

    Eric Russell 13013 (10/28/2010)


    I still think that combining a logical identifier like client_id or store_id with another column containing either a date/time stamp or sequential integer makes more sense than...

  • RE: Are There That Many GUIDs?

    Paul White NZ (10/26/2010)


    Craig-315134 (10/26/2010)


    It would seem there are now more posts on the subject of GUIDS than there are GUIDS. 😀

    :laugh: Yes, this is always a hotly-debated topic. ...

  • RE: Are There That Many GUIDs?

    Eric Russell 13013 (10/26/2010)


    I'm not intentionally trying to throw gasoline on the fire, but I'd just like to point out that, since a GUID is basically a combination of various...

  • RE: Are There That Many GUIDs?

    Jeff Moden (10/25/2010)


    Thomas-282729 (10/25/2010)


    It amazes me that top notch developers still try to prematurely optimize.

    You and I may be talking about two different things. Doing it right to begin...

  • RE: Are There That Many GUIDs?

    A GUID is actually 16 bytes, but perhaps you only meant that a GUID is 12 bytes more than a 4 byte Int.

    Yes. I was referring to the delta...

  • RE: Are There That Many GUIDs?

    It amazes me that many folks forget about such things as the load on backups and maintenance plans and that just because you have memory and blazing disk speeds that...

Viewing 15 posts - 1 through 15 (of 72 total)