Are the posted questions getting worse?
-
Everyone bow their head in a moment of silence.
'14-'15 ski season is over.
-
Steve Jones - SSC Editor (4/7/2015)
Everyone bow their head in a moment of silence.'14-'15 ski season is over.
<taps commences playing>
Day is done,
gone the sun....
-
Steve Jones - SSC Editor (4/7/2015)
Everyone bow their head in a moment of silence.'14-'15 ski season is over.
My condolences on your loss. Not to worry...it'll be back again this year. In the mean time, you have baseball.
Brandie Tarvin (4/7/2015)
<taps commences playing>Day is done,
gone the sun....
I don't think the sun is gone...that's part of his problem.
-
The most IMPORTANT Avenger. HA!
-
Steve Jones - SSC Editor (4/7/2015)
Everyone bow their head in a moment of silence.'14-'15 ski season is over.
Powder?
-
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?
--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) -
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...
😎
-
Brandie Tarvin (4/3/2015)
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
No, it was never rescinded after Vatican II, almost everyone thinks it was though. Even my mother didn't believe me when I told her. I've had confirmation from multiple priests that it is still a rule.My parents still don't eat meat on Fridays. But nowadays that's more because fish is healthier than most meat.
I try to eat vegetarian twice a week; not necessarily on Fridays. Most of the time it's one day actual vegatarian meat-replacements and one day pasta or rice. Then I eat bacon for the rest of the week. 😀
BAAAACCCCCCOOOOOOOONNNNNNNNNN!
YEAH!
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
Alan.B (4/7/2015)
Brandie Tarvin (4/3/2015)
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
No, it was never rescinded after Vatican II, almost everyone thinks it was though. Even my mother didn't believe me when I told her. I've had confirmation from multiple priests that it is still a rule.My parents still don't eat meat on Fridays. But nowadays that's more because fish is healthier than most meat.
I try to eat vegetarian twice a week; not necessarily on Fridays. Most of the time it's one day actual vegatarian meat-replacements and one day pasta or rice. Then I eat bacon for the rest of the week. 😀
BAAAACCCCCCOOOOOOOONNNNNNNNNN!
YEAH!
No, the answer is OBESITY 😀
-
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...
😎
Yeah, I would call it SQL Server 2016. 2015 seems highly unlikely.
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 -
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...
😎
It's much more difficult to go from 2005 to 2014 because of the rule of 2 revisions. Our plan was to do the "easy" upgrade to 2012 and then start planning for the release after 2014, whatever it turns out to be.
Rumor has it that 2014 sucks almost as bad as 2012 for SSMS and has a similar mistake as the retro mistake they made in 2012.
--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) -
Luis Cazares (4/7/2015)
Alan.B (4/7/2015)
Brandie Tarvin (4/3/2015)
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
No, it was never rescinded after Vatican II, almost everyone thinks it was though. Even my mother didn't believe me when I told her. I've had confirmation from multiple priests that it is still a rule.My parents still don't eat meat on Fridays. But nowadays that's more because fish is healthier than most meat.
I try to eat vegetarian twice a week; not necessarily on Fridays. Most of the time it's one day actual vegatarian meat-replacements and one day pasta or rice. Then I eat bacon for the rest of the week. 😀
BAAAACCCCCCOOOOOOOONNNNNNNNNN!
YEAH!
No, the answer is OBESITY 😀
So, pass the bacon and get the hell out of the way! 😀
--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) -
Jeff Moden (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...
😎
It's much more difficult to go from 2005 to 2014 because of the rule of 2 revisions. Our plan was to do the "easy" upgrade to 2012 and then start planning for the release after 2014, whatever it turns out to be.
Rumor has it that 2014 sucks almost as bad as 2012 for SSMS and has a similar mistake as the retro mistake they made in 2012.
It's not a rumor. SSMS 2014 SUCKS!
If SSMS crashes - you've lost your work. There is no auto-recovery.
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 -
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.
My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]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
Viewing 15 posts - 48,076 through 48,090 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply