Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

Sending multiple rows to the Database from an Application: Part II Expand / Collapse
Author
Message
Posted Thursday, October 28, 2010 2:16 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 1,182, Visits: 1,969
I see references to OPENXML in the postings.

Don't use OPENXML! Use XQuery. See the following SQL ServerCentral article:
http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx



(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.
Post #1012640
Posted Thursday, October 28, 2010 2:28 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 4, 2014 7:31 AM
Points: 117, Visits: 176
Mauve (10/28/2010)
I see references to OPENXML in the postings.

Don't use OPENXML! Use XQuery. See the following SQL ServerCentral article:
http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx


True, but BE WEARY of element based xml depending on your Sql Server Version.

http://connect.microsoft.com/SQLServer/feedback/details/250407/insert-from-nodes-with-element-based-xml-has-poor-performance-on-sp2-with-x64

Note, there are more versions affected than the url suggests.




Post #1012647
Posted Thursday, October 28, 2010 2:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 1,182, Visits: 1,969
sholliday (10/28/2010)
Mauve (10/28/2010)
I see references to OPENXML in the postings.

Don't use OPENXML! Use XQuery. See the following SQL ServerCentral article:
http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx


True, but BE WEARY of element based xml depending on your Sql Server Version.

http://connect.microsoft.com/SQLServer/feedback/details/250407/insert-from-nodes-with-element-based-xml-has-poor-performance-on-sp2-with-x64

Note, there are more versions affected than the url suggests.


It's a defect. It will be, or has been, fixed.
I'm also on SQL Server 2008 R2 (x64).

We're successfully using the XML approach as a data transport mechanism between our .Net SaaS web application and the stored procedures in the database. Works quite well. The XML is a hybrid (Attribute & Element) but mostly Attribute centric.



(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.
Post #1012658
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse