October 22, 2010 at 7:26 am
To get you started .... assume every documented pigeon has one male and one female pigeon for parents.
Attached a little brainstorm to start with an experiment on the hierarchy datatype.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 22, 2010 at 7:28 am
Craig Farrell (10/21/2010)
Alvin Ramard (10/21/2010)
Stefan Krzywicki (10/21/2010)
Q: Explain how to determine if a table has a primary key?Lock the database, if the table can get back in, it has a key.
That's not 100% correct. You have to specify a primary lock. If you used a secondary lock then you may have proven that the table had a secondary key instead of a primary one.
Imagine going to an interview and being asked a question about DBCC TimeWarp. 😀 :w00t:
Well, that all depends on if they want the Jan 2020 version, the Mar 3010 version, or that broken piece of crap that came out in May 2095 that they took 15 years trying to correct before realizing they could just DBCC Timewarp the 2020 back into place.
Once upon a time....I nailed an interview with the answer "hamster poo"
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 22, 2010 at 7:31 am
ALZDBA (10/22/2010)
To get you started .... assume every documented pigeon has one male and one female pigeon for parents.Attached a little brainstorm to start with an experiment on the hierarchy datatype.
Why did you have to mention Genealogy? Now I'll have to get caught up on what this is all about!!! 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2010 at 7:31 am
GSquared (10/22/2010)
Jeff Moden (10/21/2010)
ALZDBA (10/20/2010)
Dito.And it only serves a single purpose. i.e. strict hierarchy.
Ever tried building a family tree ?
Thanks for the input, Johan. Heh... from what I've seen, even nested sets have some difficulty with family trees.
I'm not sure how you could do a valid nested sets hierarchy for a real geneology. Pedigree collapse alone would make it at least prohibitively difficult, if not impossible. Nested sets only work well for inverse-pyramid hierarchies. You could do it by having each person exist in two hierarchy ranges (paternal, maternal), but charting it out into human-useful data becomes difficult, and you'd have to increase the range of valid values for each tier as each new generation is added, which makes planning the ranges difficult. (That's usually the biggest difficulty with nested sets hierarchies.) Then, of course, if you find out that an ancestor a few generations back actually had a different father than you originally thought, you run into the other major difficulty with nested sets, which is moving nodes around is a pain.
Family trees are actually one of the few places where I think having two hierarchy ID entries per person might actually work. It's a relatively (pun intended) static, deep, path-style hierarchy. Updates are going to be rare, inserts will usually be at the end of the path, and so on, which avoids the performance issues associated with these things. You'll run into some issues with mid-path corrections, but I don't know if they'll be as bad as nested sets on that or not. Easy enough to do a proof on that.
You might run into problems with the maximum data size on hierarchy IDs if you're doing a REALLY large family tree, but real-world limitations on data availability probably make this a moot point.
I'll have to generate some test data on this and see how it goes. Haven't tried it before. Based on prior experience, adjacency will probably be easier to work with and about as fast, but that's surmise, not proof.
So, in short, for those of us who don't know WHAT THE HELL YOU'RE TALKING ABOUT and just want to track great-great-great-great-great-grand-uncle Billy, this might be useful?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 22, 2010 at 7:41 am
GSquared (10/22/2010)
You might run into problems with the maximum data size on hierarchy IDs if you're doing a REALLY large family tree, but real-world limitations on data availability probably make this a moot point.
I've been gathering information for years and I only have around 3000 people in my database. As far as personal databases are concerned size should not be an issue. Now, if you looked at the World Connect Project database, that could be a different story.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2010 at 9:00 am
Alvin Ramard (10/22/2010)
GSquared (10/22/2010)
You might run into problems with the maximum data size on hierarchy IDs if you're doing a REALLY large family tree, but real-world limitations on data availability probably make this a moot point.I've been gathering information for years and I only have around 3000 people in my database. As far as personal databases are concerned size should not be an issue. Now, if you looked at the World Connect Project database, that could be a different story.
wow, 3000, that's impressive. I think about doing this occasionally, do you store images of the documents somewhere to certify the relationships, or do you just keep the relationships?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 22, 2010 at 9:03 am
ALZDBA (10/22/2010)
Jeff Moden (10/21/2010)
ALZDBA (10/20/2010)
Dito.And it only serves a single purpose. i.e. strict hierarchy.
Ever tried building a family tree ?
Thanks for the input, Johan. Heh... from what I've seen, even nested sets have some difficulty with family trees.
and we didn't even mention IVF ( in virto fertilization )
or the alike stuff of reproduction.
Should we sugest a new msconnect topic: the new SQLnext datatype: Genealogy :hehe:
Another issue would be how to handle "genetic" parents vs. "legal" parents. (Remember the story how to become your own grandpa? It starts with getting married to a "slightly" younger women and your daughter's getting married to her dad making your daughter your stepmother...)
I think current versions of any kind of family tree
October 22, 2010 at 9:12 am
LutzM (10/22/2010)
ALZDBA (10/22/2010)
Jeff Moden (10/21/2010)
ALZDBA (10/20/2010)
Dito.And it only serves a single purpose. i.e. strict hierarchy.
Ever tried building a family tree ?
Thanks for the input, Johan. Heh... from what I've seen, even nested sets have some difficulty with family trees.
and we didn't even mention IVF ( in virto fertilization )
or the alike stuff of reproduction.
Should we sugest a new msconnect topic: the new SQLnext datatype: Genealogy :hehe:
Another issue would be how to handle "genetic" parents vs. "legal" parents. (Remember the story how to become your own grandpa? It starts with getting married to a "slightly" younger women and your daughter's getting married to her dad making your daughter your stepmother...)
I think current versions of any kind of family tree
How and what you do depneds on the data model you use. Some data models have no problem dealing with this
... back to my meeting. Later folks ......
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2010 at 9:12 am
I love this reply from one of the regulars over at SQLTeam
Have a look at your post and then think about if we can understand what you want...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2010 at 10:59 am
LutzM (10/22/2010)
ALZDBA (10/22/2010)
Jeff Moden (10/21/2010)
ALZDBA (10/20/2010)
Dito.And it only serves a single purpose. i.e. strict hierarchy.
Ever tried building a family tree ?
Thanks for the input, Johan. Heh... from what I've seen, even nested sets have some difficulty with family trees.
and we didn't even mention IVF ( in virto fertilization )
or the alike stuff of reproduction.
Should we sugest a new msconnect topic: the new SQLnext datatype: Genealogy :hehe:
Another issue would be how to handle "genetic" parents vs. "legal" parents. (Remember the story how to become your own grandpa? It starts with getting married to a "slightly" younger women and your daughter's getting married to her dad making your daughter your stepmother...)
I think current versions of any kind of family tree
Hence the pigeons in use with my attached model. There is makes it way better acceptable as when we would use humans.
Everybody knows about the phenomenon, but nobody talks about it :Whistling:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 22, 2010 at 11:01 am
GilaMonster
I love this reply from one of the regulars over at SQLTeamHave a look at your post and then think about if we can understand what you want...
Hey, If I understand enough to ask you to design my question for me, then you should be able to understand enough to know what I want.
Right?
October 22, 2010 at 12:17 pm
Brandie Tarvin (10/22/2010)
GilaMonster
I love this reply from one of the regulars over at SQLTeamHave a look at your post and then think about if we can understand what you want...
Hey, If I understand enough to ask you to design my question for me, then you should be able to understand enough to know what I want.
Right?
New company: SQL Psychics. Just send money, we've already got it built for you.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 22, 2010 at 1:42 pm
[rant]
I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2010 at 1:50 pm
Alvin Ramard (10/22/2010)
[rant]I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
Heh, DTS to SSIS "What the hell do you mean I got to set up the source 400 times instead of dragging a pipe?" level of not learning, or "Ey! what's dis buttan dooo?" not learning? 😛
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 22, 2010 at 2:24 pm
GilaMonster (10/22/2010)
I love this reply from one of the regulars over at SQLTeamHave a look at your post and then think about if we can understand what you want...
Good answer
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 20,731 through 20,745 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply