>3. Joins are always expensive. Querying a large de-normalized table with proper indexes will always return data faster than querying a highly normalized table that requires multiple joins even with correct indexes.
As you are mentioning "proper indexes" - is there anything like our SYS(3054) in SQL Server?
>4.
http://www.sqlservercentral.com/ is a great site for SQL developers. It is to SQL what the UT is to VFP developers. Check it out.
Thanks for the tip!
Patrick