Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQLServerCentral.com » Anything that is NOT about SQL! » Are the posted questions getting worse?
Add to briefcase
40,326 posts, Page 3,909 of 4,033
«««3,9073,9083,9093,9103,911»»»

Are the posted questions getting worse? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
SQLRNNR
Posted Thursday, March 07, 2013 9:25 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858, Visits: 12,443
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML.

The only possible reason is so you can say your indexes are SeXI.


That and to give manufacturers the incentive to make even larger and faster storage devices, CPUs, switches, routers, interfaces, and backup devices.


Don't forget the need for fiber between every endpoint.


Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1428366
dwain.c
Posted Thursday, March 07, 2013 9:28 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:37 PM
Points: 2,370, Visits: 3,252
SQLRNNR (3/7/2013)
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML.

The only possible reason is so you can say your indexes are SeXI.


That and to give manufacturers the incentive to make even larger and faster storage devices, CPUs, switches, routers, interfaces, and backup devices.


Don't forget the need for fiber between every endpoint.


I try to make sure there's enough fiber in my diet to avoid any clogs between my endpoints.

No loops! No CURSORs! No RBAR! Hoo-uh!

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?

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Are you too recursively challenged?
Splitting strings based on patterns can be fast!
Post #1428368
Revenant
Posted Thursday, March 07, 2013 9:31 PM


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: Yesterday @ 4:25 PM
Points: 3,511, Visits: 2,593
SQLRNNR (3/7/2013)
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML.

The only possible reason is so you can say your indexes are SeXI.


That and to give manufacturers the incentive to make even larger and faster storage devices, CPUs, switches, routers, interfaces, and backup devices.


Don't forget the need for fiber between every endpoint.

And remember that XML is the native format for SOAP, and at the time it was introduced it was just GREAT!

Of course, now I am defining the interfaces as JSON.
Post #1428370
SQLRNNR
Posted Thursday, March 07, 2013 9:55 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858, Visits: 12,443
Revenant (3/7/2013)
SQLRNNR (3/7/2013)
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML.

The only possible reason is so you can say your indexes are SeXI.


That and to give manufacturers the incentive to make even larger and faster storage devices, CPUs, switches, routers, interfaces, and backup devices.


Don't forget the need for fiber between every endpoint.

And remember that XML is the native format for SOAP, and at the time it was introduced it was just GREAT!

Of course, now I am defining the interfaces as JSON.


YUCK


Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1428377
Lynn Pettis
Posted Thursday, March 07, 2013 11:14 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 11:14 PM
Points: 21,832, Visits: 27,862
Me thinks we may have had an epiphany.


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 #1428403
L' Eomot Inversé
Posted Friday, March 08, 2013 4:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 7,185, Visits: 7,285
SQLRNNR (3/7/2013)
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML.

The only possible reason is so you can say your indexes are SeXI.


That and to give manufacturers the incentive to make even larger and faster storage devices, CPUs, switches, routers, interfaces, and backup devices.

Don't forget the need for fiber between every endpoint.

No, fibre's not fast enough to cope with verbose nonsense like XML - just ensure that the signal path between each pair of nodes (not just endpoints, switches and routers too) in the network is good empty vacuum - light's faster in vacuum than in fibre.

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

http://es.linkedin.com/in/tomthomsonsoftware
Post #1428501
Matt Miller (#4)
Posted Friday, March 08, 2013 10:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:52 PM
Points: 7,002, Visits: 14,001
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.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #1428698
Jeff Moden
Posted Friday, March 08, 2013 8:28 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 11:54 PM
Points: 33,113, Visits: 27,041
SQLRNNR (3/7/2013)
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML.

The only possible reason is so you can say your indexes are SeXI.


That and to give manufacturers the incentive to make even larger and faster storage devices, CPUs, switches, routers, interfaces, and backup devices.


Don't forget the need for fiber between every endpoint.


I'm getting old. That now has a double meaning for me.

--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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1428836
Jeff Moden
Posted Friday, March 08, 2013 8:45 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 11:54 PM
Points: 33,113, Visits: 27,041
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.

--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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1428838
Matt Miller (#4)
Posted Saturday, March 09, 2013 7:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:52 PM
Points: 7,002, Visits: 14,001
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.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #1428882
« Prev Topic | Next Topic »

Add to briefcase
40,326 posts, Page 3,909 of 4,033
«««3,9073,9083,9093,9103,911»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.