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 «««3,9083,9093,9103,9113,912»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Saturday, March 9, 2013 2:19 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 3:25 PM
Points: 857, Visits: 7,452
Jeff Moden (3/8/2013)
Matt Miller (#4) (3/8/2013)
Jeff Moden (3/7/2013)
Revenant (3/4/2013)
Evil Kraig F (3/4/2013)
Revenant (3/4/2013)
I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this case parsing multilevel XML with multiple occurrences of the same tag, yet prohibits use of a tool that would make it a breeze - in this case XML LINQ via CLR Integration.


Sorry Revenant. Don't mean to be the cause of your frustration in this case. Clean CLR isn't what scares my DBA's, it's letting my app coders loose with it.

It was not meant at you, Craig. I have been in that situation and I know how it feels.


I feel the same way... I just can't understand why anyone would actually use XML.


Well I'd say XML would be like a lot of other items -it's a tool in the arsenal. Use it correctly and it can be VERY useful; use it badly or in the wrong context, and it blows up in your face.

Kind of like any other tool.


I strongly agree with the "right tool" sentiment. I just don't agree that XML is the right tool for the transmittal of data destined for a relational database. It seems like using a 100 ton crane to turn a monkey wrench especially when it's used to transmit otherwise flat data for a single database entity. Since I'm mostly a data troll, I've not read up on JSON but if it's a markup language that requires description tags for each row or each element, I'm not going to be very happy with that for data transmission, either.


It is, but the construction means that the same size of data fits in a file 2/3 the size of an XML file and it is directly queryable which makes it good for client-side apps.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1428936
Posted Sunday, March 10, 2013 3:36 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:58 PM
Points: 3,422, Visits: 5,366
Jeff Moden (3/8/2013)

...Since I'm mostly a data troll...


Does that mean you live under a bridge on Al Gore's information superhighway?



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1428964
Posted Sunday, March 10, 2013 1:17 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 20,799, Visits: 32,717
Okay, first, I am not apologizing for what or how I said it. I am curious, however, if anyone thinks I went to far here.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1429011
Posted Sunday, March 10, 2013 1:28 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:03 AM
Points: 40,385, Visits: 36,829
Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do this for me'.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1429013
Posted Sunday, March 10, 2013 1:32 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 20,799, Visits: 32,717
GilaMonster (3/10/2013)
Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do this for me'.


Not a strech for me at all. I have no scheduled jobs on my computer here at home, so no data to work with. My development VM at work has no scheduled jobs, so again no data. The production systems are in theater (such as Afghanistan) on secure networks, so again, no data.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1429016
Posted Sunday, March 10, 2013 1:34 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 20,799, Visits: 32,717
GilaMonster (3/10/2013)
Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do this for me'.


Plus, look how long he has been around here and at his sig block.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1429017
Posted Sunday, March 10, 2013 2:15 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:03 AM
Points: 40,385, Visits: 36,829
Fine, you're right, I'm wrong, etc, etc.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1429019
Posted Sunday, March 10, 2013 3:12 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 20,799, Visits: 32,717
GilaMonster (3/10/2013)
Fine, you're right, I'm wrong, etc, etc.


Is there an echo in here?? How many times I have felt that way here.

No, you aren't wrong, just that I don't have any data to work with and I really don't feel compelled to make any in this case. More than willing to help, just give me something to work with is all I want.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1429024
Posted Sunday, March 10, 2013 3:24 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:50 PM
Points: 1,061, Visits: 2,580
Lynn Pettis (3/10/2013)
GilaMonster (3/10/2013)
Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do this for me'.


Plus, look how long he has been around here and at his sig block.


I've participated in an exchange on these forums with this person. I don't recall the circumstances, but I do recall thinking that someone who expects strangers to help solve his/her problems for free probably shouldn't respond indignantly to a perfectly reasonable question and definitely shouldn't insult those strangers. I see that name on a post and just walk on by.


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1429026
Posted Sunday, March 10, 2013 10:34 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:32 PM
Points: 35,546, Visits: 32,142
Matt Miller (#4) (3/9/2013)
Jeff Moden (3/8/2013)
Matt Miller (#4) (3/8/2013)
Jeff Moden (3/7/2013)
Revenant (3/4/2013)
Evil Kraig F (3/4/2013)
Revenant (3/4/2013)
I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this case parsing multilevel XML with multiple occurrences of the same tag, yet prohibits use of a tool that would make it a breeze - in this case XML LINQ via CLR Integration.


Sorry Revenant. Don't mean to be the cause of your frustration in this case. Clean CLR isn't what scares my DBA's, it's letting my app coders loose with it.

It was not meant at you, Craig. I have been in that situation and I know how it feels.


I feel the same way... I just can't understand why anyone would actually use XML.


Well I'd say XML would be like a lot of other items -it's a tool in the arsenal. Use it correctly and it can be VERY useful; use it badly or in the wrong context, and it blows up in your face.

Kind of like any other tool.


I strongly agree with the "right tool" sentiment. I just don't agree that XML is the right tool for the transmittal of data destined for a relational database. It seems like using a 100 ton crane to turn a monkey wrench especially when it's used to transmit otherwise flat data for a single database entity. Since I'm mostly a data troll, I've not read up on JSON but if it's a markup language that requires description tags for each row or each element, I'm not going to be very happy with that for data transmission, either.


Well in our case it's more like we're moving the 100-ton crane, dissassembling it in transit and making a whole bunch of 1-ton tractors along the way:). The XML is very useful in that, because it allows us some sane way to maintain the relations while the data is in transit, and still have some control over data types etc.... Besides - we leverage an industry-specific interchange spec which was specified using XML, so it also opens us up to all sorts of pre-made tools to help us.



I get all of that especially when someone makes a "standard". Heh... EDI is another "standard" (which I also dislike only worse than XML) that does the type of thing you seem to be doing. With the understanding that I don't know what the actual complexities of what you've need to do actually are, there are some pretty simple ways to do some pretty complex things. XML certainly does what you want it to but it reminds me of buying a stick of gum and carrying it home in a full size shopping bag.

My take on it is that just because millions of people are using it, I don't have to think they're right. Unfortunately, because there are millions of people using it, I do have to put up with using it on occasion.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1429064
« Prev Topic | Next Topic »

Add to briefcase «««3,9083,9093,9103,9113,912»»»

Permissions Expand / Collapse