|
Comments
|
|
information is useful, but better explanation of hierarchyid is needed and there many features left unexplained.
|
|
|
A better explanation of why this new datatype and method is better than the 'old' method of using a self-referencing key to define employee hierachies.
|
|
|
Neat
|
|
|
HIERARCHYID is in essence an optimized materialized path method. As such it provides very effective method to store hierarchies, and the variety of CLR method available make querying a lot easier than traditional hierarchy methods. Here is a good overview of HIERARCHYID with more details: http://msdn.microsoft.com/en-us/library/bb677173.aspx
|
|
|
an interesting exposure, but not much explanation of techiniques or syntax used
|
|
Mark Orlando on
7/24/2009
Excellent...just what I was looking for. Only downside is the code was not available for download.
|
|
|
Went by too fast to understand
|
|
|
Once again, very good Plamen. But providig code would also be very nice with your videos...
|
|
|
Code for this video been added as a refernce - upper right corner!
|
|
|
not much to it :P
|
|
George Maddux on
7/28/2009
Hard to understand speaker. Too heavy an accent
|
|
Steve Harris on
8/24/2009
Not enough detail. What are the methods associated with the new HIERARCHYID data type? The way you use them in the select and update statements also seems to be complex and was not talked about in the video.
|
|
|
Steve,
There are many methods and the video format is not long enough to demonstrate all in detail. Here is reference to all methods with details:
http://msdn.microsoft.com/en-us/library/bb677193.aspx
|
|
Richard Cook on
9/18/2009
Concise look at updating a record in hierarchy. Are there some advanced concepts?
|
|
|
Richard, here are a few links to details on more advanced topic like enforcing a particular hierarchy, converting from another method, etc.:
http://technet.microsoft.com/en-us/library/bb677212.aspx
http://technet.microsoft.com/en-us/library/bb677173.aspx
http://technet.microsoft.com/en-us/library/bb677213.aspx
Getting to more advanced concepts requires navigating to particular usage scenario and exploring the specifics of the implementation.
|
|
Keith Badeau on
5/18/2011
Thanks for this video and all the others you've done, I'm always looking forward to watching them.
|
|
|
good
|
|
|
very hard to understand commentator
|
|
|
Too brief, not nearly enough detail.
|
|
Michael Sidley on
12/23/2011
Would have been helpful to learn the basics of how the hierarchyid works but maybe that was in another video.
|
|
|
I do not currently work w/ org charts, but have in the past. This is a wonderful addition by SQL. I would have like to see it go one step further, showing an SSRS report using the heirachy type to create the chart
|
|
|
Not all method calls are explained. This is a tough trade-off: short vs. comprehensive. However in an introductory video, perhaps the function of each method should at least be mentioned. Great video. Good English! Well done!
|
|
T. Carnahan on
12/29/2011
Some background/syntax on the various functions would be helpful.
|
|
|
Wow! This is a very powerful addition to SQL Server that I did not know about. Thanks.
|
|
|
Most of the time I love these videos because their brief. However, I didn't understand when I would implement this feature in a real world scenario. I was a little confused after the video. A little more explanation about the functionality would have been helpful.
|
|
|
Good
|