Talk:97 Things SQL

From WikiContent

Revision as of 20:34, 5 October 2009 by Amachanic (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
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