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,3584,3594,3604,3614,362»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2014 4:28 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 3:06 PM
Points: 33,169, Visits: 15,304
GilaMonster (4/1/2014)
Hey Steve (if you're listening), can I indirectly toss some flames into that WIT editorial comments?


Skiing today, but enjoy.

I decided I can't communicate with those two and I'll stay out of it.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1557268
Posted Tuesday, April 1, 2014 4:32 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 @ 1:53 PM
Points: 42,771, Visits: 35,870
Steve Jones - SSC Editor (4/1/2014)
GilaMonster (4/1/2014)
Hey Steve (if you're listening), can I indirectly toss some flames into that WIT editorial comments?


Skiing today, but enjoy.


Hehe, permission to throw flames and go to bed...



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 #1557271
Posted Tuesday, April 1, 2014 4:39 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 8,689, Visits: 9,223
GilaMonster (4/1/2014)
Python
Thanks, Gail.
That's rather an old language, not a new one - I guess you meant new to you, rather than new in itself.

I don't have too much beef with the language, but the way the fans talk about it, you'd think it was about to end poverty and bring about world peace.

I guess it's not too bad, but the hype is excessive. But "not too bad" doesn't mean "good" - for example anything that includes functional programming without tail recursion optimisation is anathema to me (and I'm pretty sure it doesn't include memoisation either, which although probably less important still suggests crap performance). It's a bit of a kitchen sink language, tries to cover many incompatible programming paradigms, but with silliness like the exclusion of first class continuations (which appeared to be a point of principle with the language's inventor) it is impossible to do anything like declarative functional programming and it probably screws up the other paradigms too. But last time I looked at it seriously, instead of just casually, was about 20 years ago, so anything I say about it is either be 20 years out of date or based on skim reading papers or casual conversations, not hard knowledge of where it is today.
Learning it cause I'm bored (nothing to do at work today, meetings tomorrow and thursday, new work next week) and because I'm probably going to be doing some work in google's app engine for a friend, and that's python-based.
Learning new programming languages to relieve the boredom is something I understand extremely well - I've been doing it since the bad old days when learning was from paper because there was no internet. Having a potential use for the language is a nice bonus.
Besides, more languages = more diversity. No learning is wasted.

I couldn't agree more. Have you tried learning Haskell yet? It's definitely fun!


Tom
Post #1557274
Posted Tuesday, April 1, 2014 4:48 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 @ 1:53 PM
Points: 42,771, Visits: 35,870
TomThomson (4/1/2014)
GilaMonster (4/1/2014)
Python
Thanks, Gail.
That's rather an old language, not a new one - I guess you meant new to you, rather than new in itself.


Indeed.

Besides, more languages = more diversity. No learning is wasted.

I couldn't agree more. Have you tried learning Haskell yet? It's definitely fun!


I haven't. Had a online friend years ago (when newsgroups were still a thing) who acted like Haskell was the second coming. Put me off a bit.
F# is on the to-learn-soon list (for loose definitions of the word 'soon'), so may well take another look at Haskell then



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 #1557278
Posted Tuesday, April 1, 2014 4:55 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 15,646, Visits: 28,027
GilaMonster (4/1/2014)

I don't have too much beef with the language, but the way the fans talk about it, you'd think it was about to end poverty and bring about world peace.


That's just crazy talk. Everyone knows that Git is going to end poverty, bring about world peace and make coffee in the morning.


----------------------------------------------------
"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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1557279
Posted Tuesday, April 1, 2014 6:25 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 8,689, Visits: 9,223
GilaMonster (4/1/2014)
I haven't. Had a online friend years ago (when newsgroups were still a thing) who acted like Haskell was the second coming. Put me off a bit.
F# is on the to-learn-soon list (for loose definitions of the word 'soon'), so may well take another look at Haskell then

I absolutely hate hearing about a language that is the second coming, or the answer to all our problems, or the language that will enable everyone to write bug-free software or anything like that. If anyone ever suggested Haskell was such a language, they were an idiot. Everyone else whose name is on the first Haskell report agreed with me about that. We improve programming languages slowly (but surely) but I believe that we will never have an idiot-proof language - and I haven't yet met a programmer who wasn't sometimes an idiot (that includes myself, btw).


Tom
Post #1557284
Posted Tuesday, April 1, 2014 8:31 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 4,171, Visits: 3,201
TomThomson (4/1/2014)
GilaMonster (4/1/2014)
I haven't. Had a online friend years ago (when newsgroups were still a thing) who acted like Haskell was the second coming. Put me off a bit.
F# is on the to-learn-soon list (for loose definitions of the word 'soon'), so may well take another look at Haskell then

I absolutely hate hearing about a language that is the second coming, or the answer to all our problems, or the language that will enable everyone to write bug-free software or anything like that. If anyone ever suggested Haskell was such a language, they were an idiot. Everyone else whose name is on the first Haskell report agreed with me about that. We improve programming languages slowly (but surely) but I believe that we will never have an idiot-proof language - and I haven't yet met a programmer who wasn't sometimes an idiot (that includes myself, btw).

I have to agree wholeheartedly with Tom here. Some people think that a single language is going to handle web page layout, all facets of data access, multimedia, all cross-browser idiosyncrasies, encryption and even the overall design. It'll do everything with layers of obfuscation but yet write perfect, efficient SQL to query any database platform. By the very design of the language, bugs will be a thing of the past. Of course, we'll never have to patch anything ever again because it'll all be thought of before v1.0 is even released.

I've heard about how Ruby was going to save the world. Now, judging by how many Git ads I receive, the push is on for that to be the next big thing. I think I'll stick with what works well for now.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1557297
Posted Tuesday, April 1, 2014 9:48 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: 2 days ago @ 4:14 AM
Points: 3,618, Visits: 5,254
I nominate this as about the most annoying SQL error message I've seen in a long time:

Cannot use the ROLLBACK statement within an INSERT-EXEC statement.




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 #1557306
Posted Tuesday, April 1, 2014 11: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 @ 3:51 PM
Points: 36,959, Visits: 31,469
TomThomson (4/1/2014)
GilaMonster (4/1/2014)
I haven't. Had a online friend years ago (when newsgroups were still a thing) who acted like Haskell was the second coming. Put me off a bit.
F# is on the to-learn-soon list (for loose definitions of the word 'soon'), so may well take another look at Haskell then

I absolutely hate hearing about a language that is the second coming, or the answer to all our problems, or the language that will enable everyone to write bug-free software or anything like that. If anyone ever suggested Haskell was such a language, they were an idiot. Everyone else whose name is on the first Haskell report agreed with me about that. We improve programming languages slowly (but surely) but I believe that we will never have an idiot-proof language - and I haven't yet met a programmer who wasn't sometimes an idiot (that includes myself, btw).


One of my favorite sayings is "If something is idiot proof, only idiots will use it".


--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 #1557312
Posted Wednesday, April 2, 2014 2:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:28 PM
Points: 2,983, Visits: 5,399
I worked with one dev, when I did a bit dev, pity I don't do as mush I as I'd, we still use ON ERROR GOTO don't we?

Anyway it was in VB.Net and I introduced him to TRY CATCH FINALLY.

Only the CATCH just did a response.write to the page, so no real handling of the error. Only in a slightly lighter white than the page background. You probably have guessed where this is going...
He was on holiday and we were getting calls saying data wasn't being saved. So I had a look, sat with the user for 10 - 15 minutes and it just so happened that the light caught the monitor at the right angle that I could see something at the top of the page. So I tilted the monitor and sure enough could see the error message.

So basically every other record wasn't being inserted into the database.
Took me about a day first of change the catch to give meaningful messages than I could see, and then to correct the error. He was full of sunshine when he came back until we had a chat. Our boss both managed to see the funny side and take him down a peg or two!

Rodders...



Post #1557361
« Prev Topic | Next Topic »

Add to briefcase «««4,3584,3594,3604,3614,362»»»

Permissions Expand / Collapse