So, once again I find myself needing to do a SQL University post on a topic we have already covered this semester. Which also means that once again I am going to mail it in and just point you to the post I wrote earlier, which is also a re-post of something I had already written.
I suppose at some point I should really take a look at that SQL University syllabus more then a day or two before my post is due.