December 6, 2016 at 3:10 pm
Now you're just making up stuff to support your claims.
No, I get called in every now and then by product developers a lot of different SQL companies to make suggestions about optimizers, standards conformance, and (let us be honest) act is sort of a neutral guy who wanted them in legal trouble if I tell one set of developers with another set of developers is doing (think of it as back channel diplomacy; so lawyers and NDAs do not get involved).
Most people here are not at all interested in creating portable implementations of their code.
That is probably true; and most programmers are not very good (I am sure you agree with that statement:-)). Most of them have less than 20 years experience, and most have not worked with really larger systems or really critical systems (by that I mean things that can kill or seriously injure a large number of people).
They probably have used one product (SQL server on this forum) and never had to leave it. They do not know about other products (Oracle, DB2, Teradata, etc.) or exotic specialized data products. Yet if their enterprises successful, they will find out about them the hard way. "“Forgive him Theodotus: he is a barbarian and thinks that the customs of his tribe and island are the laws of nature.”
- Caesar and Cleopatra, George Bernard Shaw"
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
December 6, 2016 at 4:13 pm
CELKO (12/6/2016)
Now you're just making up stuff to support your claims.
No, I get called in every now and then by product developers a lot of different SQL companies to make suggestions about optimizers, standards conformance, and (let us be honest) act is sort of a neutral guy who wanted them in legal trouble if I tell one set of developers with another set of developers is doing (think of it as back channel diplomacy; so lawyers and NDAs do not get involved).
This is known as the Anecdotal Fallacy. You are providing anecdotal evidence suggesting that it is representative of a widespread problem. But, you have not provided any proof that the problems you related were due to use of proprietary dialect nor that these problems really are representative of a widespread issue.
You simply have not provided any proof of your claim that
CELKO (12/6/2016)
Using proprietary dialect constructs like CROSS APPLY and TOP make optimization difficult
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 6, 2016 at 7:21 pm
CELKO:
1) Take yous ISO elsewhere. This is a SQL Server specific forum and at least 97.4% of the people here couldn't care less. BTW, I'm being generous giving you 2.6%.
2) Was there a single thing you said in your first diatribe that would actually help the OP? Wait, pretend i didn't ask the question. It was completely rhetorical. No one here wants to hear any response from you on that one - we already know the answer.
3) Regarding the RIDICULOUS statement about CROSS APPLY and performance, go do some research on Adam Machanic and the INCREDIBLE performance and scale he gets on massive data warehouse queries using that construct.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply