# I Suck! ## I Suck! posted on Tuesday, July 06, 2004 8:41 PM Yeah, yeah, I'm sorry I've been negelecting you my lovely reader. There's just a whole lot to play with at the moment, just got a [reasonably priced Video Camera](http://products.sony.co.uk/productdetail.asp?id=11_61_6019), my [lovely bike](http://www.specialized.com/SBCBkModel.jsp?spid=5955), been playing with VS.NET 2005 Beta 1, getting a new deployment (and tracking down a deadlock) on [this site](http://www.icslearn.co.uk/) and finally playing with [Adobe Premiere Pro](http://www.adobe.com/products/premiere/main.html) - which is just awesome, if you've been stuck with [Windows Movie Maker](http://www.microsoft.com/windowsxp/using/moviemaker/default.mspx), try a real editing package! Whew...as well as that I've been looking into [SQL Hierarchies](http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=273960) using something called ['Nested Sets' by Joe Celko](http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=273960) - this really is the best way I've seen of doing hierarchies (well, trees) in SQL. Also ordered his book on the subject [Joe Celko's Trees and Hierarchies in SQL for Smarties](http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/mostlylucid-21) ...so, with all of that I have to get back to this site. I was very aware that I was just [metablogging](http://crofsblogs.typepad.com/ckbetas/2003/07/metablogging.html) for a while there which I personally can't stand. So,l no promises but I'll try and get back to things as soon as I can! UPDATE: Ooh, this is a pretty complex subject and really pretty interesting. There's a couple of other links I can recommend [this site](http://troels.arvin.dk/db/rdbms/links/) has the most complete set of links to the best methods of modelling hiearchical data in T-SQL, this [site has a really nice method](http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm) for supporting Nested Sets in a basically 'automatic' way. There's a whole lot to learn about this topic (much of which is mentioned in the [book I mentioned earlier](http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/mostlylucid-21)) and articles [like this](http://www.dbazine.com/tropashko4.shtml) on the ['Nested Interval' model](http://www.dbazine.com/tropashko4.shtml) look really useful but will take a bit of work to figure out. Luckily the system I'm developing is fairly loosely coupled in it's Schema, allowing me to easily upgrade the hierarchical model I use if necessary...