Viewing 15 posts - 1 through 15 (of 30 total)
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 ?
July 8, 2011 at 11:22 am
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.
July 8, 2011 at 8:41 am
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. 😉
July 5, 2011 at 7:07 am
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...
June 30, 2011 at 12:30 pm
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...
June 30, 2011 at 11:12 am
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.
June 30, 2011 at 6:19 am
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...
June 30, 2011 at 1:58 am
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...
April 28, 2011 at 3:29 am
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',...
April 28, 2011 at 3:15 am
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...
April 28, 2011 at 2:47 am
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...
April 28, 2011 at 2:45 am
Tom.Thomson (4/28/2011)
April 28, 2011 at 2:29 am
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...
April 27, 2011 at 11:59 am
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...
April 27, 2011 at 11:05 am
GSquared (4/27/2011)
This particular data has an order to the tuples
:alien:
April 27, 2011 at 9:24 am
Viewing 15 posts - 1 through 15 (of 30 total)