Since I use hierarchies in almost every database I've developed several SPs and UDFs to handle the requirements of this test. I keep a "pivot" perm table just for this...
Quest Software SQL Turbo is for full text searches. From Quest's website "SQL Turbo is a revolutionary new software tool which dramatically increases the speed of SQL Server's free text...