Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 43,426 through 43,440 (of 66,738 total)

You must be logged in to reply to this topic. Login to reply

paul.knibbs SSCoach Points: 15320 More actions · Answer 1

Well, it's not a totally unreasonable position, so long as you actually know what you're talking about...

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 2

paul.knibbs (3/26/2014)
Well, it's not a totally unreasonable position, so long as you actually know what you're talking about...

Maybe. I mean, the organization I was with is still using SQL Server, 15 years on. So we shouldn't use all the stuff that SQL offers that's outside the ANSI standard so we can switch, even though we're not switching and all that stuff that's outside the ANSI standard could really speed things up or make things work better? That's an odd stance. Just sayin'.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

paul.knibbs (3/26/2014)
Well, it's not a totally unreasonable position, so long as you actually know what you're talking about...

Are any of the Hekaton/columnstore features part of the ANSI standard?

It would seem hard to believe they do.

So you can't use any of the performance benefits because it is not "standard"?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

paul.knibbs SSCoach Points: 15320 More actions · Answer 4

Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something that might be needed, even if not for the particular example cited.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

paul.knibbs (3/26/2014)
Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something that might be needed, even if not for the particular example cited.

I'm not arguing against you, but against Celko-alike people 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 6

paul.knibbs (3/26/2014)
Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something that might be needed, even if not for the particular example cited.

Yeah, if cross-platform compatibility is needed, this may be something desirable. I agree. But for most systems, I couldn't support it.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

Grant Fritchey (3/26/2014)
paul.knibbs (3/26/2014)
Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something that might be needed, even if not for the particular example cited.
Yeah, if cross-platform compatibility is needed, this may be something desirable. I agree. But for most systems, I couldn't support it.

I couldn't either. Cursors in SQL Server are pathetically slow, but in Oracle they're blazing fast. Date handling in the two platforms is so completely different that they don't even resemble one another. Besides, if you want any performance at all, you'll use all the tools available to you unless they're going to be deprecated.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

andrew gothard SSChampion Points: 12315 More actions · Answer 8

Otherwise how can you nimbly shift between different platforms." And then he got vehement about it. It was fun.

If they think THAT is a good idea, that's a "Thank you for your time" right there

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.

WayneS SSC Guru Points: 95460 More actions · Answer 9

SQLRNNR (3/25/2014)
Grant Fritchey (3/25/2014)
He got vehement about it. It was fun.
I can imagine the fun that could be had. :ermm:

It could even be scary...

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

WayneS (3/26/2014)
SQLRNNR (3/25/2014)
Grant Fritchey (3/25/2014)
He got vehement about it. It was fun.
I can imagine the fun that could be had. :ermm:
It could even be scary...

Don't poke the bear. Or in this case, it could be fun to poke the bear.:-D

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 11

FYI: We've released an SSMS plugin that accesses scripts here on the site (and your briefcase) from within SSMS.

It's here: http://www.sqlservercentral.com/Scripts/

Download and try it out. Comments welcome here: http://www.sqlservercentral.com/Forums/Forum83-1.aspx

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 12

Ed Wagner (3/26/2014)
Cursors in SQL Server are pathetically slow, but in Oracle they're blazing fast.

I guess I wouldn't say such a thing... I worked in Oracle for about 3 years and I have to tell you that I was able to write some set based code in Oracle that made Oracle cursors seem pretty pathetic even when compared to SQL Server.

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

rodjkidd SSCoach Points: 15916 More actions · Answer 13

So SQL Bits session voting has opened, I've picked my 10 which out of nearly 300 submitted was tough. Good luck to anyone who has submitted from the Thread.

Rodders...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

That's a hell of a lot of sessions submitted...

p.s. did you get the bribe I sent? :hehe:

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 15

GilaMonster (3/27/2014)
That's a hell of a lot of sessions submitted...
p.s. did you get the bribe I sent? :hehe:

No. Can you please resend it? 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP