Talk:97 Things SQL

From WikiContent

Revision as of 20:33, 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:

A) XML. All vendors deal with XML differently and it is not, to my knowledge, part of the Standard. (XQuery being another story, somewhat) B) Query optimizer topics. Optimization is handled quite differently by different products. C) Exception handling. D) 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: A) Hierarchies. Oracle has CONNECT BY PRIOR, SQL Server uses recursive CTEs and also has a type called HierarchyId B) Metadata. Obviously way different for each provider. C) Waits and queues

Personal tools