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 «««4,3424,3434,3444,3454,346»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, March 26, 2014 4:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:31 PM
Points: 14,000, Visits: 28,381
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1554869
Posted Wednesday, March 26, 2014 5:39 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 4,453, Visits: 3,905
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
Post #1554891
Posted Wednesday, March 26, 2014 7:40 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:46 AM
Points: 311, Visits: 3,511
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.
Post #1554949
Posted Wednesday, March 26, 2014 8:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:11 AM
Points: 5,366, Visits: 8,981
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.


It could even be scary...


Wayne
Microsoft Certified Master: SQL Server 2008
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1554978
Posted Wednesday, March 26, 2014 8:20 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:51 PM
Points: 17,948, Visits: 15,947
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.


It could even be scary...


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




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1554979
Posted Wednesday, March 26, 2014 8:56 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 6:53 PM
Points: 31,279, Visits: 15,739
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1555009
Posted Wednesday, March 26, 2014 3:09 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 35,549, Visits: 32,145
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."

(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 #1555181
Posted Thursday, March 27, 2014 5:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 2,855, Visits: 5,823
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...



Post #1555360
Posted Thursday, March 27, 2014 5:43 AM


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
That's a hell of a lot of sessions submitted...

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



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 #1555369
Posted Thursday, March 27, 2014 5:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
GilaMonster (3/27/2014)
That's a hell of a lot of sessions submitted...

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


No. Can you please resend it?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1555375
« Prev Topic | Next Topic »

Add to briefcase «««4,3424,3434,3444,3454,346»»»

Permissions Expand / Collapse