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,0634,0644,0654,0664,067»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Sunday, July 21, 2013 1:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:25 AM
Points: 13,349, Visits: 10,211
Grant Fritchey (7/19/2013)
Sean Lange (7/19/2013)

We have from time to time started heading in a bad direction. The good news is that there always seems to be a few people around here who remind us or nudge us back to the "good side". I am pretty sure that most of the "regulars" around here have been on both sides of that nudging once or twice.

I think that by not having those idiotic reputation points we have served ourselves and our community well in the long run. To be honest, a down vote is quite rude. Many times it is somebody who is honestly trying to help but posts a less then optimal solution. At least around here we tend to educate not only the OP but also the responder in those cases. The lack of reputation points I think eliminates some of the BS favorites type of crap. We can stick to what is important, the question and not stroking our egos.



What's that?

I can't hear you since you have less than 10,000 points.


Almost there! And be ready for the noise I'll make!




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 #1475835
Posted Monday, July 22, 2013 1:46 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 9:19 PM
Points: 605, Visits: 1,691
All this talk of cow pies has reminded me of an article I read in a science journal about evolution and survival of the fittest.

With dung beetles the males are generally divided into two types: big beefy dudes and scrawny buggers, and the big beefy dudes are not so bright.

When the cow pie is ready several dung beetles, around 7-8 per pie, dig tunnels towards the centre where they each make a nest. Eventually a female moves into the nest and the male waits outside guarding the entrance until the female is ready to mate. He only moves if dislodged by a bigger, beefier dude. Pretty standard “survival of the fittest”, but what’s a scrawny bugger to do?

Having a bit more brain, the scrawny bugger creeps up and discretely digs a secret tunnel. He burrows halfway in then makes a right-angled turn and digs *around* the pie. Soon he breaks into another tunnel and heads towards the female whilst the big beefy dude stands outside in the cold. When finished, he continues his traverse around the pie and its tunnels until he comes back to his own secret tunnel and leaves. Genetically all the pie can end scrawny with the big beefy dudes having no idea.

In SQL-speak, this seems like a highly desirable form of looping. TBAT, if you will.


Fal.

Post #1475889
Posted Monday, July 22, 2013 6:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 3:04 PM
Points: 6,582, Visits: 8,861
Leave it to Fal to figure out how to tie poop in with SQL

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 #1475991
Posted Monday, July 22, 2013 9:54 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:11 AM
Points: 961, Visits: 4,990
Always fun having a slow, gawd can I sneak out yet, sort of day...

Sure, I've got some projects, but anything that requires a server reboot is out, and the big project is on hold until the SAN guys get around to re-purposing a shelf of disks so my one server can get more drive space so I can start moving forward on migrating people off a Windows Server 2008 to Server 2008 R2 VM...

And even that will still be a fairly slow paced job, move a couple DBs at a time, work with the devs to make sure any SSIS packages are going to work right on the new server, then pick a day and time to pull the trigger...

So, I'm keeping myself amused by looking at what I should be looking at to baseline my servers performance, what counters, etc. Yeah, theoritaclly, this should already be done, but I have no indication the previous DBA ever did this...
Post #1476099
Posted Monday, July 22, 2013 10:24 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:21 PM
Points: 1,210, Visits: 2,512
Fal (7/22/2013)
All this talk of cow pies has reminded me of an article I read in a science journal about evolution and survival of the fittest.

With dung beetles the males are generally divided into two types: big beefy dudes and scrawny buggers, and the big beefy dudes are not so bright.

When the cow pie is ready several dung beetles, around 7-8 per pie, dig tunnels towards the centre where they each make a nest. Eventually a female moves into the nest and the male waits outside guarding the entrance until the female is ready to mate. He only moves if dislodged by a bigger, beefier dude. Pretty standard “survival of the fittest”, but what’s a scrawny bugger to do?

Having a bit more brain, the scrawny bugger creeps up and discretely digs a secret tunnel. He burrows halfway in then makes a right-angled turn and digs *around* the pie. Soon he breaks into another tunnel and heads towards the female whilst the big beefy dude stands outside in the cold. When finished, he continues his traverse around the pie and its tunnels until he comes back to his own secret tunnel and leaves. Genetically all the pie can end scrawny with the big beefy dudes having no idea.

In SQL-speak, this seems like a highly desirable form of looping. TBAT, if you will.


Fal.



While the "tunnel-by-tunnel" part may be hard work for the scrawny dude, I think the payoff probably means that he wouldn't consider it "agonizing".


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1476122
Posted Monday, July 22, 2013 11:31 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:11 AM
Points: 961, Visits: 4,990
It says something about the sort of advice / recommendations someone gives, that if I see their name as responding to a post, regardless of the subject, I click it.

ALL HAIL THE MIGHTY GAIL SHAW!
Post #1476163
Posted Monday, July 22, 2013 2:07 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:46 AM
Points: 8,573, Visits: 9,078
dwain.c (7/17/2013)
Brandie Tarvin (7/17/2013)
WHOO HOO!

Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly with a Cross Applied Tally table and an INNER JOIN inside the USING clause.

<SnoopyDance>

And it only took me 30 minutes to figure it all out.


One thing to take care with when using MERGE though: A Hazard of Using the SQL Merge Statement

It's not a bug it's a feature, but does have the potential to cause you grief if you don't know about it.

That reference is one of the most stupid pieces of nonsense I've ever seen. First the guy says he wants to merge his source into his target. Then he produces a chunk of code which does something like that. But the result of that is not what was required, because it's failed to delete a row that was in the target but not matched in the source - in other words, because it failed to violate his stated requirement in a particular way in which he wants his stated requirement violated. He then produces a piece of utterly silly code which just destroys his target and substitutes the source - and we are supposed to be surprised that that doesn't work. Then he produces, finally, his code which is the answer to the problem - but it doesn't meet his stated requirement, because it does indeed achieve the violation of that requirement that he introduced earlier to do job which he apparently wants, instead of the requirement that was actually fulfilled by the first piece of code he rejected. I just hope that I never have to deal with a developer or a DBA who leant from that guy!


Tom
Post #1476254
Posted Monday, July 22, 2013 2:17 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:14 PM
Points: 13,126, Visits: 11,964
L' Eomot Inversé (7/22/2013)
dwain.c (7/17/2013)
Brandie Tarvin (7/17/2013)
WHOO HOO!

Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly with a Cross Applied Tally table and an INNER JOIN inside the USING clause.

<SnoopyDance>

And it only took me 30 minutes to figure it all out.


One thing to take care with when using MERGE though: A Hazard of Using the SQL Merge Statement

It's not a bug it's a feature, but does have the potential to cause you grief if you don't know about it.

That reference is one of the most stupid pieces of nonsense I've ever seen. First the guy says he wants to merge his source into his target. Then he produces a chunk of code which does something like that. But the result of that is not what was required, because it's failed to delete a row that was in the target but not matched in the source - in other words, because it failed to violate his stated requirement in a particular way in which he wants his stated requirement violated. He then produces a piece of utterly silly code which just destroys his target and substitutes the source - and we are supposed to be surprised that that doesn't work. Then he produces, finally, his code which is the answer to the problem - but it doesn't meet his stated requirement, because it does indeed achieve the violation of that requirement that he introduced earlier to do job which he apparently wants, instead of the requirement that was actually fulfilled by the first piece of code he rejected. I just hope that I never have to deal with a developer or a DBA who leant from that guy!


Gosh Tom, how do you really feel about that article???


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1476262
Posted Monday, July 22, 2013 2:20 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:46 AM
Points: 8,573, Visits: 9,078
Brandie Tarvin (7/19/2013)
Did not read the author's name when I read the article. Sorry. Didn't realize it was you.

Snap
And I was a good deal more precisely nasty than you.


Tom
Post #1476264
Posted Monday, July 22, 2013 2:35 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:46 AM
Points: 8,573, Visits: 9,078
jasona.work (7/19/2013)
Stefan Krzywicki (7/19/2013)
I don't think you want me mailing those to you. And it isn't like they need baking either.


What kind of cow pies are you talking about?

I meant these: Cow Pies

In Britain no-one will understand either of you. Cow pies are what a certain desperate superhero eats. He even has a statue (without pie, unfortunately) in Dundee.


Tom
Post #1476271
« Prev Topic | Next Topic »

Add to briefcase «««4,0634,0644,0654,0664,067»»»

Permissions Expand / Collapse