What do you want to see regarding XML support in the next version of SQL Server?

re: What do you want to see regarding XML support in the next version of SQL Server?

lexp — Sat, 26 Nov 2005 12:35:02 GMT

Maybe XSLT transformations of database schema? This would be very cool for transforming old databases.

re: What do you want to see regarding XML support in the next version of SQL Server?

PP — Sat, 26 Nov 2005 15:57:22 GMT

Please provide examples on
1. Most COMMONLY performed TASKS
For example accessing Node, attribute...
2. Would love to see COMMON Functions
3. In quite a number of site, I see people asking same SET of questions again-n-again, if those can to provided as SAMPLE code or HELPER functions, that would be great
4. Performance Statistics

re: What do you want to see regarding XML support in the next version of SQL Server?

Peter Lillevold — Sat, 26 Nov 2005 20:00:09 GMT

High performance updates/changes to xml documents stored in SQL Server. Today that is quite an expensive operation.

re: What do you want to see regarding XML support in the next version of SQL Server?

nd — Tue, 10 Jan 2006 18:06:25 GMT

Please remove the HYPE about it and propose real scenarios when you can use xml better than any other possible technology. By the way so far I haven't come accross one yet.

Don't get me wrong I think there has to be something. My experience in dbms does not permit me see any "real" advantage in using xml in a rdbms.

Cheers,

re: What do you want to see regarding XML support in the next version of SQL Server?

John — Thu, 06 Apr 2006 18:58:22 GMT

1. Performance
2. more powerful update features
3. relational integrity (?) outch;)

re: What do you want to see regarding XML support in the next version of SQL Server?

P R B — Wed, 26 Jul 2006 15:02:24 GMT

I'd like to see faster .modify operations.

re: What do you want to see regarding XML support in the next version of SQL Server?

Balaji Mishra — Wed, 13 Sep 2006 11:05:11 GMT

1. Building XML relationship like tables are joined.

2. Merge XML data, Split(with query() method it's doable to some extent)

3. Support for Dynamic input params in the xml methods(value(),query(),nodes() etc). (Currently query() method supports it)

4. Reverse of FOR XML i.e., get a tabular representation of XML (it's doable using nodes()) using a single method/function

5. Better XML indexing like index on specific Nodes that's queried heavily(aka Non Clustered Index with inlcuded columns in SQL 2005) instead of whole xml column.

6. Computed column with indexing option to supporting at least scalar returend value from xml method operations. (curretly udf has to be created to do the same)

7. More examples of xml in sql books online

Thanks

Michael Rys What do you want to see regarding XML support in the next | fix my credit

Wed, 17 Jun 2009 05:00:49 GMT

PingBack from http://fixmycrediteasily.info/story.php?id=7394