Forum Replies Created

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

  • RE: Indexes, Indexes, Indexes

    Ninja's_RGR'us (7/8/2011)


    It was like that in 2000 and I don't see why it should have changed since.

    Did I said it changed ?

  • RE: Indexes, Indexes, Indexes

    I was wrong.

    Even if I think I never saw 2 tables with the same object_id within an instance, Object_id is unique only within a database according to MSDN.

  • RE: Indexes, Indexes, Indexes

    Actually object_id in both views sys.dm_db_index_usage_stats and sys.indexes refers to the index's table.

    Check MSDN for column description of each views.

    So it's fine. 😉

  • RE: First Normal Form

    What are you talking about ?

    I was saying that the only kind of key is what is called candidate key. We should call candidate key, just key.

    Of course a super-key...

  • RE: First Normal Form

    CELKO (6/30/2011)


    He does not talk about candidate keys, super keys, etc.

    Yes indeed.

    Notice that he mentioned the candidate key, but dosen't talk about it.

    The term "key" has been used in...

  • RE: First Normal Form

    From what I've learned on relational theory I understand that every attribute of a relation is composed of a name and a domain, a type.

    As Hugh Darwen define it (An...

  • RE: First Normal Form

    A table is in 1NF when every column has a fixed simple data-type that is understood by the database system, and every row has a primary key.

    This is your...

  • RE: Normalization

    So there is no logical difference between Relation and Table ?

    What Date is saying is that :

    When you read a table. Because of it's 2 dimensional representation, you might think...

  • RE: Normalization

    Read the entire post. There is domain definition in it.

    Of course there was debate about the word "atomicity".

    Is the VARHAR(5) string 'Hello' atomic ?

    Can we decompose it in 'H', 'e',...

  • RE: Normalization

    David Burrows (4/28/2011)


    Steven993 (4/27/2011)

    I actually have Date on Database Writings 2000-2006 under my eyes.

    Chapter 8, 30 apges is dedicated to that topic.

    p127

    Definition

    A table is normalized - equivalently, it is in...

  • RE: Normalization

    David Burrows (4/28/2011)


    Steven993 (4/27/2011)


    David Burrows (4/27/2011)


    Your example shows violation of Codd's 1NF and is what I understood to be 1NF.

    My example, you mean AddressLine table ? It's is not a...

  • RE: Normalization

    Tom.Thomson (4/28/2011)


    The problem, David, is that Steven (and maybe also you) are saying plainly and clearly that Date's definition (quoted by Gus) is wrong; but it is completely correct. ...

  • RE: Normalization

    You don't know what is a relation.

    You can't see the difference between relation and table......

    I actually have Date on Database Writings 2000-2006 under my eyes.

    Chapter 8, 30 apges is dedicated...

  • RE: Normalization

    David Burrows (4/27/2011)


    Your example shows violation of Codd's 1NF and is what I understood to be 1NF.

    My example, you mean AddressLine table ? It's is not a 1NF violation..

    David Burrows...

  • RE: Normalization

    GSquared (4/27/2011)


    This particular data has an order to the tuples

    :alien:

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