August 23, 2011 at 9:14 pm
Comments posted to this topic are about the item Pop Tarts and Hurricanes
August 23, 2011 at 10:50 pm
That has got to be an error in the data. Pop-tarts? Really?
I do agree that one should invest in writing better performing code. It just makes sense. It makes sense for more than just your career growth. It also makes sense to write better code to help prevent you from constantly redoing that code and allowing you time to breath or work on other things.
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
August 24, 2011 at 3:45 am
About writing better code, this is important. Where I work we do code review once a week and that does not need to take much time at all but knowledge gets spread and everyone gets the chance get pointers and give some. If you do not do this, I would strongly recommend it.
August 24, 2011 at 7:28 am
If you could recommend one source for or method of learning to write better SQL code what would it be.
I know this is something I struggle with, there is so much SQL info out there that it is hard to know where to start or even if a particular set of info is correct. I WANT to improve my SQL and I am trying as best I can by reading blogs and articles etc... but it all feels very haphazard. I wish there was a more definitive path or set of resources I could use to become better at writing efficient high performance SQL code.
August 24, 2011 at 8:50 am
Why the surprise? Pop-Tarts are quite possibly the perfect food. Box of pop-tarts, box of Twinkies, jug of water and a cockroach for company, you're set to withstand nuclear holocaust....:-P
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
August 24, 2011 at 9:03 am
krowley (8/24/2011)
If you could recommend one source for or method of learning to write better SQL code what would it be.I know this is something I struggle with, there is so much SQL info out there that it is hard to know where to start or even if a particular set of info is correct. I WANT to improve my SQL and I am trying as best I can by reading blogs and articles etc... but it all feels very haphazard. I wish there was a more definitive path or set of resources I could use to become better at writing efficient high performance SQL code.
We are looking for a Stairway series on this. I think right now I'd recommend Kevin Kline's SQL in a Nutshell as a way to organize a path to general SQL. From there, I think reading Itzik Ben-Gan, Jeff Moden, a few of the people that really write top notch SQL is the way to improve your skills.
Tackle Phil Factor's Speed Pheak challenges[/url] or the T-SQL Challenges[/url] and practice understanding what others do to solve some complex problems.
August 24, 2011 at 9:05 am
jcrawf02 (8/24/2011)
Why the surprise? Pop-Tarts are quite possibly the perfect food. Box of pop-tarts, box of Twinkies, jug of water and a cockroach for company, you're set to withstand nuclear holocaust....:-P
I agree. If you need sealed food, no heat, energy, pop-tarts make sense. Better than canned food, don't spoil, not super healthy, but easy to carry and handle in a short term emergency
August 24, 2011 at 9:33 am
Steve Jones - SSC Editor (8/24/2011)
jcrawf02 (8/24/2011)
Why the surprise? Pop-Tarts are quite possibly the perfect food. Box of pop-tarts, box of Twinkies, jug of water and a cockroach for company, you're set to withstand nuclear holocaust....:-PI agree. If you need sealed food, no heat, energy, pop-tarts make sense. Better than canned food, don't spoil, not super healthy, but easy to carry and handle in a short term emergency
Are you serious? Really? You'd consider buying Pop-Tarts in a survival situation?
My high regard for you and your opinions has taken a serious blow. :w00t:
August 24, 2011 at 9:35 am
Steve Jones - SSC Editor (8/24/2011)
. . . Tackle Phil Factor's Speed Pheak challenges[/url] or the T-SQL Challenges[/url] and practice understanding what others do to solve some complex problems.
Absolutely correct, Steve.
It happens very rarely that I agree so strongly with someone's recommendation that I feel compelled to endorse it; this is one of those rare cases.
August 24, 2011 at 9:57 am
Love this post! As a business user it is a fabulous experience when all of the data points to something never thought of, never marketed, and never expected.
Thank you SQL code writers and thank you SQL,
Annette with Windward
August 24, 2011 at 9:59 am
RML51 (8/24/2011)
Steve Jones - SSC Editor (8/24/2011)
jcrawf02 (8/24/2011)
Why the surprise? Pop-Tarts are quite possibly the perfect food. Box of pop-tarts, box of Twinkies, jug of water and a cockroach for company, you're set to withstand nuclear holocaust....:-PI agree. If you need sealed food, no heat, energy, pop-tarts make sense. Better than canned food, don't spoil, not super healthy, but easy to carry and handle in a short term emergency
Are you serious? Really? You'd consider buying Pop-Tarts in a survival situation?
My high regard for you and your opinions has taken a serious blow. :w00t:
With kids, yep. Beef jerky would be in there, lots of water, other stuff, but pop tarts are a good long lasting food. Like twinkies, they can live in your house for years.
It's not that you live on them, but they make good energy snacks. I prefer protein bars, but the kids like pop tarts
August 25, 2011 at 2:24 am
I concur that poptarts (although we don't really have these much in the UK) would be useful in a survival situation but I'd still want to do further investigations into the motives behind the trend.
My hypothesis would be that in a situation where you are getting for a hurricane you will not be dedicating as much time to looking after the kids etc so you up the amont of convenience foods you buy.
I think big data is good, and being able to draw out insight like this but how successful the insight could be implemented to have benefit is reliant on understanding the reasons behind the behaviour.
For instance, if you straight out assumed they sold for survival rations and you migrated most of your stock to the survival section and it turned out the increase in sales was due to the convenience factor then you might actually see a decrease in sales whilst exasperating customers at a critical time.
Understanding the WHY is just as important as knowing the WHAT for me since without the WHY you can't guarantee you've taken the right action based on information.
August 26, 2011 at 12:50 pm
I love pop tarts although not as much as the mcdonalds steak burrito, which apparantly is not carried anywhere in the south, except for central florida where I live, as when I ask for it they have no idea what I am talking about.
Ed Watson aka SQLGator
Microsoft SQL Server MVP
Follow me on Twitter!
Go Gators!
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply