April 7, 2015 at 7:42 pm
dwain.c (4/7/2015)
I just posted this to "The Worst Comments" discussion thread:dwain.c (4/7/2015)
-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar
-- gave me this code on a SQL forum.
-- Call him if it doesn't work.
Now that's scary!
Haven't gotten any calls yet though.
http://www.sqlservercentral.com/Forums/FindPost1675182.aspx
It got me to wondering about people that come to seek help on forums. Is there truth in coding? In other words, do they tell their bosses that in order to solve this problem for their work, they had to seek and receive help on a forum, or do they otherwise take personal credit in an effort to appear a superstar.
Not that I mind either way, mind you. I try to post helpful answers because it is fun. Just wondering out loud.
If someone took credit for someone else's work they no longer have any credibility with me. That's lying; who wants to work with a liar.
I respect people that use SSC however (and give credit where credit is do); it's a valuable resource. That means that they are resourceful and know where to go to get good answers. You still have to know a few things to identify a good solution.
I am a consultant and sometimes end up on the bench for a week or so. During that time I sometimes mentor others on SQL or a BI topic. The first thing I do is ask if they're on SSC and suggest they do so ASAP if they're not.
-- Itzik Ben-Gan 2001
April 7, 2015 at 7:51 pm
dwain.c (4/7/2015)
I just posted this to "The Worst Comments" discussion thread:dwain.c (4/7/2015)
-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar
-- gave me this code on a SQL forum.
-- Call him if it doesn't work.
Now that's scary!
Haven't gotten any calls yet though.
http://www.sqlservercentral.com/Forums/FindPost1675182.aspx
It got me to wondering about people that come to seek help on forums. Is there truth in coding? In other words, do they tell their bosses that in order to solve this problem for their work, they had to seek and receive help on a forum, or do they otherwise take personal credit in an effort to appear a superstar.
Not that I mind either way, mind you. I try to post helpful answers because it is fun. Just wondering out loud.
That's awesome. I should post more code so I can get that someday.
"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
April 7, 2015 at 8:30 pm
Eirikur Eiriksson (4/7/2015)
Jeff Moden (4/7/2015)
I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades now and really beginning to work with the system especially in SSMS. Between that and the bloody metro garbage, I've never seen more screwed up code in my life even including 2005 RTM. What a piece of junk. What were they thinking? Considering I installed 2012 SP2 CU4 SSMS, I'll also ask what ARE they thinking. Maybe a better question would be, ARE they thinking?Yeah... I recently found out that CU5 came out on March 16th because of retro code that made it in. Does that actually fix all the garbage going on in CU4 other than the HA stuff they messed up on?
Congratulations, you've just opened a tin of worms. Quick hint, skip 2012 and go for 2014, much better! Of course In few months 2015 is going to be much better...
😎
Except some of us don't have the choice. My corporate office isn't approving 2014 for release yet. Next up is 2012.
Jeff, how bad is it? I'm going to be installing in the next month or two.
April 7, 2015 at 10:04 pm
SQLRNNR (4/7/2015)
It's not a rumor. SSMS 2014 SUCKS!If SSMS crashes - you've lost your work. There is no auto-recovery.
SQL Prompt
Tab Recovery
April 7, 2015 at 10:09 pm
Not sure if anyone here knew Larry Toothman (https://www.facebook.com/larry.toothman.7?hc_location=ufi, https://twitter.com/iowatechbear). He's a fellow speaker and part of the SQL community in Iowa. He had a stroke this past weekend and it looks like he may not survive.
Thoughts and prayers to him and sorry to break the news.
Life is short. Remember that.
April 8, 2015 at 3:46 am
Steve,
Thanks for letting us know. I saw Argenis tweet yesterday but didn't know the reason. Haven't spoken to Larry before but I've seen him at the last Summit and probably the one before. Sad news.
Rodders...
April 8, 2015 at 6:39 am
Brandie Tarvin (4/7/2015)
Eirikur Eiriksson (4/7/2015)
Jeff Moden (4/7/2015)
I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades now and really beginning to work with the system especially in SSMS. Between that and the bloody metro garbage, I've never seen more screwed up code in my life even including 2005 RTM. What a piece of junk. What were they thinking? Considering I installed 2012 SP2 CU4 SSMS, I'll also ask what ARE they thinking. Maybe a better question would be, ARE they thinking?Yeah... I recently found out that CU5 came out on March 16th because of retro code that made it in. Does that actually fix all the garbage going on in CU4 other than the HA stuff they messed up on?
Congratulations, you've just opened a tin of worms. Quick hint, skip 2012 and go for 2014, much better! Of course In few months 2015 is going to be much better...
😎
Except some of us don't have the choice. My corporate office isn't approving 2014 for release yet. Next up is 2012.
Jeff, how bad is it? I'm going to be installing in the next month or two.
I haven't experienced anything everly negative with SSMS in 2012, haven't done 2014 yet. The only issues I've had are that it doesn't always remember where I put my toolbars and sometimes when I shut down it reports a crash, but I actually think that is related to the RedGate tools.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 8, 2015 at 6:42 am
Grant Fritchey (4/7/2015)
dwain.c (4/7/2015)
I just posted this to "The Worst Comments" discussion thread:dwain.c (4/7/2015)
-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar
-- gave me this code on a SQL forum.
-- Call him if it doesn't work.
Now that's scary!
Haven't gotten any calls yet though.
http://www.sqlservercentral.com/Forums/FindPost1675182.aspx
It got me to wondering about people that come to seek help on forums. Is there truth in coding? In other words, do they tell their bosses that in order to solve this problem for their work, they had to seek and receive help on a forum, or do they otherwise take personal credit in an effort to appear a superstar.
Not that I mind either way, mind you. I try to post helpful answers because it is fun. Just wondering out loud.
That's awesome. I should post more code so I can get that someday.
So when the OP asked for help, they resort to blaming someone else if things go wrong?
If I ever saw this in comments in code, I would take a serious look into whether that developer needs to be cut loose.
They were responsible for what is put into production, not Dwaine.C
What an attitude....credit for the help, fine.
Best scenario I can see - production issue, and no code with comments like this are causing the issue.
But the pieces that are causing problems point to the poster.
I wonder what they do when a coworker helps them?
Who obviously would have much more insight into the whole picture when helping out?
April 8, 2015 at 6:46 am
dwain.c (4/7/2015)
dwain.c (4/7/2015)
-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar
-- gave me this code on a SQL forum.
-- Call him if it doesn't work.
Now that's scary!
How did you find that? Did someone contact you saying they'd seen that in their code base?
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
April 8, 2015 at 6:53 am
GilaMonster (4/8/2015)
dwain.c (4/7/2015)
I just posted this to "The Worst Comments" discussion thread:dwain.c (4/7/2015)
-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar
-- gave me this code on a SQL forum.
-- Call him if it doesn't work.
Now that's scary!
How did you find that? Did someone contact you saying they'd seen that in their code base?
No actually, it was a prediction of what might be found if one looks hard enough. 😛
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?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
April 8, 2015 at 6:56 am
SQLRNNR (4/3/2015)
Is it really no meat, or are we saying that fish is not a meat because it is a vegetable so fish is acceptable?
.
I think it's to do with concessions to the rich and powerful being made because they didn't want to be having to eat 'peasant food'. Fish was not the only exception, this was followed by, for instance, otter - because that also lives in water. The church is not big on taxonomy.
Clearly, fish is not a vegetable. A point which not only the church, but a significant part of the population and indeed the catering industry seem wholle unable to grasp, given how heartily sick I have become of pointing this out after 35 years of being a vegetarian, given the number of people intent on convincing me that irrespective of MY views on the subject; that I do eat fish. Presumably on the assumption that if they are unable to tell the difference between a legume and a trout, I shouldn't either.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
April 8, 2015 at 7:02 am
Jack Corbett (4/8/2015)
Brandie Tarvin (4/7/2015)
Eirikur Eiriksson (4/7/2015)
Jeff Moden (4/7/2015)
I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades now and really beginning to work with the system especially in SSMS. Between that and the bloody metro garbage, I've never seen more screwed up code in my life even including 2005 RTM. What a piece of junk. What were they thinking? Considering I installed 2012 SP2 CU4 SSMS, I'll also ask what ARE they thinking. Maybe a better question would be, ARE they thinking?Yeah... I recently found out that CU5 came out on March 16th because of retro code that made it in. Does that actually fix all the garbage going on in CU4 other than the HA stuff they messed up on?
Congratulations, you've just opened a tin of worms. Quick hint, skip 2012 and go for 2014, much better! Of course In few months 2015 is going to be much better...
😎
Except some of us don't have the choice. My corporate office isn't approving 2014 for release yet. Next up is 2012.
Jeff, how bad is it? I'm going to be installing in the next month or two.
I haven't experienced anything everly negative with SSMS in 2012, haven't done 2014 yet. The only issues I've had are that it doesn't always remember where I put my toolbars and sometimes when I shut down it reports a crash, but I actually think that is related to the RedGate tools.
I'm with Jack on this. Worst problems I've had with SSMS have been the occasional glitch from Redgate tools. And you know how much I LOVE my Redgate tools. By and large SSMS hasn't been any worse than previous versions that I've noticed. And 2014, the server, is WAY better than 2012.
"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
April 8, 2015 at 7:06 am
Grant Fritchey (4/8/2015)
Jack Corbett (4/8/2015)
Brandie Tarvin (4/7/2015)
Eirikur Eiriksson (4/7/2015)
Jeff Moden (4/7/2015)
I'd put off doing anything with SQL Server 2012 until I actually needed it. I'm doing installs for upgrades now and really beginning to work with the system especially in SSMS. Between that and the bloody metro garbage, I've never seen more screwed up code in my life even including 2005 RTM. What a piece of junk. What were they thinking? Considering I installed 2012 SP2 CU4 SSMS, I'll also ask what ARE they thinking. Maybe a better question would be, ARE they thinking?Yeah... I recently found out that CU5 came out on March 16th because of retro code that made it in. Does that actually fix all the garbage going on in CU4 other than the HA stuff they messed up on?
Congratulations, you've just opened a tin of worms. Quick hint, skip 2012 and go for 2014, much better! Of course In few months 2015 is going to be much better...
😎
Except some of us don't have the choice. My corporate office isn't approving 2014 for release yet. Next up is 2012.
Jeff, how bad is it? I'm going to be installing in the next month or two.
I haven't experienced anything everly negative with SSMS in 2012, haven't done 2014 yet. The only issues I've had are that it doesn't always remember where I put my toolbars and sometimes when I shut down it reports a crash, but I actually think that is related to the RedGate tools.
I'm with Jack on this. Worst problems I've had with SSMS have been the occasional glitch from Redgate tools. And you know how much I LOVE my Redgate tools. By and large SSMS hasn't been any worse than previous versions that I've noticed. And 2014, the server, is WAY better than 2012.
Well, now that you mention it, I have glitches with Prompt more times than just occasionally. I've had it hang when I assume it's doing reference lookups when coding. I've also had it hang when reloading tabs. But luckily, crashing only results in a minor delay and Redgate does restore the previous tabs even in the face of a minor crash in SSMS. So, it's all good.
April 8, 2015 at 7:09 am
I use SSMS 2014 exclusively now, because I'm working on SQL Server 2014 and previous versions of SSMS don't work well up-version. The biggest annoyance is the help file. The fact that I have to download the help contents is annoying and not being able to copy from there is just insane. To be honest, I'm using google now more than F1 for syntax help.
Other than that, no problems at all. No crashes when closing and SQLPrompt saves my tab content when there's a power failure which is great. You do have to go and change the keyboard shortcuts after installing, they default to Visual Studio I think. Aaron Bernard (I think) has a blog post on the subject.
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
April 8, 2015 at 7:11 am
Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just say, not on the same wavelength as I am politically (socially I think we're all largely aligned), "your side" is seriously crossing the line[/url]. Might want to reign them in a bit.
"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
Viewing 15 posts - 48,091 through 48,105 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply