Are the posted questions getting worse?
-
Have to drop this here, since I'm proud.
My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a long journey, but he's finally done.
-
Steve Jones - SSC Editor (11/22/2016)
Have to drop this here, since I'm proud.My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a long journey, but he's finally done.
Congratulations, proud father. And the same to your son. Perseverance pays off.
-
Well done to all Steve. That's a hell of an accomplishment.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
They always come in threes don't they, we have rodiots (road idiots), phoniots (idiots with phones) and now planiots (execution plan idiots)
😎
-
GilaMonster (11/18/2016)
TomThomson (11/17/2016)
GilaMonster (11/16/2016)
Lynn Pettis (11/16/2016)
Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came in late.Actually no, that doesnt work. It gives us the current stuff, it doesn't give us what was sent out about a day ago.
Scroll down, click 'show all on demand videos' and go to the last page (11 at the moment)
Thanks, Gail.
Tom
-
BWFC (11/18/2016)[hrI wrote steak because I was so excited about the steaks that are arriving tomorrow I got carried away. I think on reflection you're right that it would probably better with something else.
What's the right meaning of guindilla? T'interweb produces lots of hits for peppers but which are the right kind of pepper?
Dried seed pod (usually shrivelled as a result) still containing the seeds, rather than fresh fruit; for something like this, Cayenne is a good choice; the pods should be snapped when put into the mix, so that the seeds can spread around and have effects on everything.
Tom
-
Steve Jones - SSC Editor (11/22/2016)
Have to drop this here, since I'm proud.My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a long journey, but he's finally done.
Congrats to you both!!! So many boys get everything done and can't seem to get the board of review part accomplished.
_______________________________________________________________
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
I just deleted a table named dbo.deleteme from our Dev box. This upset some people. Nothing surprises me anymore.
"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 (11/22/2016)
I just deleted a table named dbo.deleteme from our Dev box. This upset some people. Nothing surprises me anymore.:hehe:
-
Eirikur Eiriksson (11/22/2016)
They always come in threes don't they, we have rodiots (road idiots), phoniots (idiots with phones) and now planiots (execution plan idiots)😎
Hmmm, that is a very interesting. I added my comment on it.
I do not understand why you claim the "planiot" monicker here. The question is valid, and the scenario that causes the bad performance on PROD is a legit, and by many people severely misunderstood, artefact of how rowgoals affect optimization.
Yes, the number of rows in the plans is hugely different. But the table cardiniality is not, that number is exactly the same in both plans. There do appear to be some differences between PROD and UAT, but far more subtle than it looks at first sight.
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/ -
Steve Jones - SSC Editor (11/22/2016)
Have to drop this here, since I'm proud.My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a long journey, but he's finally done.
Congratulations. That is a big deal.
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 -
Steve Jones - SSC Editor (11/22/2016)
Have to drop this here, since I'm proud.My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a long journey, but he's finally done.
Totally awesome! Congratulations to you both! My hat is off to both of you!
--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) -
TomThomson (11/22/2016)
BWFC (11/18/2016)[hrI wrote steak because I was so excited about the steaks that are arriving tomorrow I got carried away. I think on reflection you're right that it would probably better with something else.
What's the right meaning of guindilla? T'interweb produces lots of hits for peppers but which are the right kind of pepper?
Dried seed pod (usually shrivelled as a result) still containing the seeds, rather than fresh fruit; for something like this, Cayenne is a good choice; the pods should be snapped when put into the mix, so that the seeds can spread around and have effects on everything.
I see. The next question is, would any dried chilli do? We've got loads of our own dried Hungarian Hot Wax and we buy party bags of dried chillies from the Asian grocers up the road. It looks to me like all guindillas are chillies but not all chillies are guindillas.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
Alan.B (11/22/2016)
I just deleted a table named dbo.deleteme from our Dev box. This upset some people. Nothing surprises me anymore.Impossible to resist :-D!
-
Beatrix Kiddo (11/23/2016)
Alan.B (11/22/2016)
I just deleted a table named dbo.deleteme from our Dev box. This upset some people. Nothing surprises me anymore.Impossible to resist :-D!
There used to be a folder on one of our shared drives called 'Do Not Open This Folder'. That was extremely hard to resist. To this day I'm not sure if anybody ever found out what was in it.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 15 posts - 56,746 through 56,760 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply