Michael Rys

Search

Go

• Blogs

Login

Subscriptions

• RSS 2.0
• Atom 0.3
• Contact

News

---

Upcoming Presentations

---

TechEd 2007, Orlando, June 4 to June 8, 2007

---

Books I co-authored

---

---

---

Post a Comment ::

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Tuesday, November 29, 2005 1:34 AM

Performance, performance, performance, performance, performance, performance, performance, performance, performance, performance, performance.

Mostly in transforms, but also in node selection and cloning.

Hubris Sonic

# Michael Rys - What do you want to see regarding XML support in the next version of SQL Server? @ Tuesday, November 29, 2005 12:09 PM

Anonymous

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Tuesday, November 29, 2005 3:23 PM

Support semantic web technologies: native RDF graphs in SQL Databases, best would be if it could mix with native XML trees (for example an RDF triple wich uses an XML element as it's subject to enable really cool metadata handling). of course support for some of the Querying languages is needed, maybe even an XQuery extension (for mixing native RDF, SQL and XML data)
there are only some Java or Scripted implementations wich sucks if you're using .NET

pascal germroth

# Allow sql:variable to handle an XML variable @ Tuesday, November 29, 2005 5:24 PM

A while back I posted a question, which you kindly answered. I am sure this is pretty high on your list too.

http://www.codecomments.com/printthread.php?threadid=516752

Mark Bosley

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Wednesday, November 30, 2005 1:46 PM

A way to create diagrams for XML "relationships" would be cool. For instance, one table of projects has two columns: projID, projXML. Another table of employees has two cols: empID, empXML. So projXML references employees by using empID. If we could link the two nodes (in a diagram) by dragging the empID in projXML to the empID in the employee table, I think that would rock! I guess what I'm asking for is a visual XQuery editor????

Just a pie in the sky idea - not really sure how realistic it is.

Charlie

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Thursday, December 01, 2005 11:36 PM

Some more consistent support for {sql:variable} in XQuery statements. Seems that most of the methods are intended to use "static" queries for manipulating XML.

Raj Das

# What's next for SQL Server and XML @ Thursday, December 01, 2005 11:40 PM

Anonymous

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Monday, December 05, 2005 6:19 AM

- Support for <xsd:key>, <xsd:keyref> etc.
- DRI for XML and relational tables (via <xsd:keyref> ?)
- Nodelevel locking
- Update etc. for multiple nodes at once
- More Axes (ancestor)
- Performance: Inserts are just awful if there are a lot of nodes (even without index)
- Indexed View support
- Did I mention performance?
- to have "let" would be nice
- An editor for schemas

Christoph Seck

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Friday, December 16, 2005 2:56 AM

Performance? Otherwise they'll send you back.

east germany eh

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Wednesday, December 28, 2005 11:51 AM

functions please. Without them it's unfeasible to accomplish anything resursion-related.

Oleg Tkachenko

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Saturday, January 14, 2006 10:23 PM

Please add full-text search support in xml
I want to perform searchs like

select * from
MyTable
where
xmlColumn.exist('/customer/comments[. fulltextContains("credit denied")]') > 0

Larry

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Tuesday, September 12, 2006 6:32 PM

! JOIN Support in XQuery ! please, xquery is exactly suposed to do it...

Rodrigo Gidra

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Thursday, November 02, 2006 5:00 PM

Can you please elaborate on the join functionality you want to see? You mean across XML documents stored in different or the same column?

mrys

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Monday, December 11, 2006 11:16 AM

It would seem not being able to remove an individual XSD from a schema collection is a large omission? With no ability to remove the XSD you have no ability to remove the incumbent XML namespace. In our domain this is a big headache because as users XSD schemas evolve then there is no way we can update the XSD whilst using the same XML namespace. Instead we have to modify the XML namespace and employ a system of dereferencing which is not ideal in the extreme.

Another thing we'd like to see too is lax validation.

Thanks and regards.

Damian Heaney

# re: What do you want to see regarding XML support in the next version of SQL Server? @ Tuesday, January 23, 2007 9:55 PM

Hi Damian

Thanks for the feature request. We are looking into some improvements in the schema space and your feedback will help us prioritize some of it. Please also go and file it at the connect site.

Regards
Michael

mrys