.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

To shred or not to shred

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
I'm working with a new client on a Business Intelligence (BI) application where the source data is JSON.  I figured I would use an off the shelf conversion tool to go JSON to XML and store the XML in SQL Server 2008.  For a BI application is it best practice to (1) Query Directly from XML or (2) Shred the XML and persist the relational data into tables which are then fed into the BI application?

View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend