Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).

There is no simple way to create recursive queries that have several levels of data (hierarchical data) in SQL Server 2000. A recursive query is used when you have a parent and child data stored ...