First of all, this is a great article, especially for newer folks to SQL. Now, I've noticed that these queries take quite a few minutes to run. Is this normal? I've been working with SQL for about 2 years now and haven't seen half of what you showed used anywhere else.
Once again, great article:-)