Talk:97 Things SQL

From WikiContent

Jump to: navigation, search

The list looks pretty good but I think many topics need to be moved to vendor-specific areas:

* XML. All vendors deal with XML differently and it is not, to my knowledge, part of the Standard. (XQuery being another story, somewhat)
* Query optimizer topics. Optimization is handled quite differently by different products.
* Exception handling.
* Row-level security (a hot topic in the SQL Server world where I play, and something that I don't think can be properly covered in 500 words for SQL Server)

Some other ideas for vendor-specific topics:

* Hierarchies. Oracle has CONNECT BY PRIOR, SQL Server uses recursive CTEs and also has a type called HierarchyId
* Metadata. Obviously way different for each provider.
* Waits and queues
Personal tools