Talk:97 Things SQL

From WikiContent

(Difference between revisions)
Jump to: navigation, search
(stuff that should be moved to vendor areas?)
Current revision (20:34, 5 October 2009) (edit) (undo)
(Adam tries to learn how to properly use a wiki)
 
Line 1: Line 1:
The list looks pretty good but I think many topics need to be moved to vendor-specific areas:
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)
+
* 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.
+
* Query optimizer topics. Optimization is handled quite differently by different products.
-
C) Exception handling.
+
* 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)
+
* 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:
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
+
* 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.
+
* Metadata. Obviously way different for each provider.
-
C) Waits and queues
+
* Waits and queues

Current revision

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