SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

SwePeso
Patron Saint of Lost Yaks

Sweden
30113 Posts

Posted - 01/30/2008 :  17:32:41  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by rel1976

Looks like you understand dimensionality as it relates to databases no better than the thread starter you're criticizing.
Hi and welcome to SQLTeam my russian friend!
If you want to discuss relativity and dimensions, please feel free to email me.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 01/30/2008 :  17:59:28  Show Profile  Reply with Quote
quote:
Originally posted by rel1976

quote:
Originally posted by Peso

Made me laugh good!
Just wait until he wants to introduce a fourth dimension



Looks like you understand dimensionality as it relates to databases no better than the thread starter you're criticizing.

- rel -


I'm certainly looking forward to you enlightening us. Please proceed.





CODO ERGO SUM
Go to Top of Page

rel1976
Starting Member

4 Posts

Posted - 01/30/2008 :  18:32:27  Show Profile  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by rel1976

quote:
Originally posted by Peso

Made me laugh good!
Just wait until he wants to introduce a fourth dimension



Looks like you understand dimensionality as it relates to databases no better than the thread starter you're criticizing.

- rel -


I'm certainly looking forward to you enlightening us. Please proceed.





CODO ERGO SUM



Well, since you asked nice

We'll ignore star schema design in dimensional (cube, OLAP, what-have-you) databases, other than to note that a fact table can have many dimensions (subject to implementation and hardware constraints).

Moving on, then, to relational (let's say, the "OLTP" world):

A table represents a relation. This is where the word "relational" comes from, as in "relational database", the "R" in RDBMS.

A table has some number of columns specified for it. These correspond to attributes in the relation being represented.

The dimensionality of a relation is the number of attributes it has. These correspond to placeholders in the predicate that the relation models.

So, for example, a table with 2 columns represents a relation with two attributes, models a binary predicate and is 2-dimensional. In general, a table with n columns represents a relation with n number of attributes, models an n-ary predicate, and is n-dimensional.

- rel -
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30113 Posts

Posted - 01/30/2008 :  18:36:24  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Thank you for the Class 101 notes.
As a sidenote, did you read the topic in the link?


E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 01/30/2008 18:37:06
Go to Top of Page

rel1976
Starting Member

4 Posts

Posted - 01/30/2008 :  20:00:23  Show Profile  Reply with Quote
quote:
Originally posted by Peso

Thank you for the Class 101 notes.
As a sidenote, did you read the topic in the link?


E 12°55'05.25"
N 56°04'39.16"




Yer welcome. It's just that in an industry where a practitioner can be considered an "expert" (and make a good living professionally) without even knowing the fundamentals of the field, I've learned never to take such knowledge as a given.

Does it ever blow your mind that probably the majority of people that you so patiently help and have still made "the list" on this thread get paid to do what they do?

- rel -

P.S. Yes, I read the topic.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30113 Posts

Posted - 01/30/2008 :  20:12:56  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by rel1976

Does it ever blow your mind that probably the majority of people that you so patiently help and have still made "the list" on this thread get paid to do what they do?
And your point is?


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 01/30/2008 :  21:40:29  Show Profile  Reply with Quote
quote:
Originally posted by Peso

quote:
Originally posted by rel1976

Does it ever blow your mind that probably the majority of people that you so patiently help and have still made "the list" on this thread get paid to do what they do?
And your point is?


E 12°55'05.25"
N 56°04'39.16"





apparently he is saying that he gets paid to do this too



-ec
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 01/31/2008 :  05:13:21  Show Profile  Visit spirit1's Homepage  Reply with Quote
i acctually have agree with the rel guy on the blowing the mind point.
being an "IT professional" is a very easy title to get even with the total lack of skills.
and majority never get those skills.
that'd be like having me performing a heart surgery wittout the proper medical training.
sure... i know how the heart works and looks like but hell if i feel competent to fiddle with it...



_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30113 Posts

Posted - 01/31/2008 :  05:21:27  Show Profile  Visit SwePeso's Homepage  Reply with Quote
So when a lesser experienced surgeon consults a more experienced surgeon, should the lesser experienced surgeon listen to the advice he get, or should he tell the more experienced surgeon

- No, I want to do this open heart medical procedure my way because I don't like the suggestion you gave me

I think the lesser experienced surgeon should pay attention to the advice he get, or the chances are that the lesser experienced surgeon ends up like a modern Dr Frankenstein.
For what I can tell, top 20 posters on SQLTeam have at least 250 years of combined experience is this field.


E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 01/31/2008 05:28:38
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 01/31/2008 :  05:30:04  Show Profile  Visit spirit1's Homepage  Reply with Quote
no of course not... that's not what i meant and you know it!

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30113 Posts

Posted - 01/31/2008 :  05:35:31  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Yes, I know you know I know you know.


E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 01/31/2008 05:38:40
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 01/31/2008 :  05:49:10  Show Profile  Visit spirit1's Homepage  Reply with Quote
i'm relly glad that you know i know you know i know you know.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 01/31/2008 :  09:04:45  Show Profile  Reply with Quote
Personally I think he's full of it...3 posts here, 3 at dbforums

Troll

I really think the confusion these days is that people are being "trained" tro learn buzz words and not reality

Mostly because the monkeys doing the "training" have no real world experience

http://www.google.com/search?source=ig&hl=en&rlz=1G1GGLQ_ENUS256&q=SQL+Table+Column+Dimension



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 01/31/2008 :  11:22:51  Show Profile  Reply with Quote
quote:
Originally posted by X002548
Mostly because the monkeys doing the "training" have no real world experience



I have got to agree with this.

Until these people have been in situations where they are told 'I don't care how, just get it done!', then they are mostly full of drivel.
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 02/01/2008 :  05:35:43  Show Profile  Reply with Quote
i have a bad feeling about this one...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96586

Em
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 02/01/2008 :  08:58:54  Show Profile  Reply with Quote
Relvars and relvals?

http://www.dbforums.com/showthread.php?t=1626875&page=3

http://en.wikipedia.org/wiki/Relational_database



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
6059 Posts

Posted - 02/23/2008 :  20:28:47  Show Profile  Reply with Quote
Now what would make someone go back to a thread from a month ago and delete all their posts???
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96242


Be One with the Optimizer
TG
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 02/25/2008 :  10:36:32  Show Profile  Reply with Quote
Just amazing

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97696



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 02/25/2008 :  10:54:17  Show Profile  Reply with Quote
quote:
Originally posted by X002548

Just amazing

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97696



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam




People like him are pretty much the reason for this thread.

That's nothing new for him. This is why I never respond to his posts:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57782







CODO ERGO SUM
Go to Top of Page

DavidChel
Constraint Violating Yak Guru

USA
474 Posts

Posted - 02/25/2008 :  16:59:04  Show Profile  Reply with Quote
I can't imagine acting like that and expecting anyone to be willing to help me afterwards.
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000