Talk:97 Things SQL  From WikiContent  Revision as of 20:33, 5
October 2009 by Amachanic (Talk | contribs) Jump to: navigation,
search   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