November 23, 2016 at 4:49 am
Ed Wagner (11/22/2016)
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.
Congrats to your son!
November 23, 2016 at 4:50 am
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.
HA!
November 23, 2016 at 4:51 am
Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.
Enjoy the holiday!
November 23, 2016 at 5:05 am
Brandie Tarvin (11/23/2016)
Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.Enjoy the holiday!
Happy holidays Brandie.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 23, 2016 at 5:08 am
ChrisM@Work (11/23/2016)
Brandie Tarvin (11/23/2016)
Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.Enjoy the holiday!
Happy holidays Brandie.
OMG. I LOVE IT!
November 23, 2016 at 5:09 am
Brandie Tarvin (11/23/2016)
Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.Enjoy the holiday!
Surely the denizens of The Thread are eating Cthurkey
"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
November 23, 2016 at 5:12 am
Grant Fritchey (11/23/2016)
Brandie Tarvin (11/23/2016)
Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.Enjoy the holiday!
Surely the denizens of The Thread are eating Cthurkey
Which was invented by a DBA, no less.
November 23, 2016 at 5:20 am
Hugo Kornelis (11/22/2016)
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.
The OP stated that
Here are execution plans on UAT and PROD, they seem very similar
when at the first glance the cardinality difference within the two is in the order of the third magnitude, which to me brands him as a "planiot".
😎
Liked your comment, very good!
November 23, 2016 at 7:25 am
Luis Cazares (11/18/2016)
Dear Santa,I know you won't be able to bring me a new laptop this year, but could you just bring more RAM (and a new HDD) for my current one so I can play with virtual machines just like the other kids?
Thank you.
😀
Well, when everybody in my office was requesting new laptops I told them to buy me more RAM and call it even. They saved money and now I can not only run some decent sized VM's but the performance increase is like night and day. While everyone else ended up with a marginal upgrade I think I ended up with a better deal.
November 23, 2016 at 8:08 am
What is on your menu for Thanksgiving?
Can you share any recipes?
Our family will be having Thanksgiving at my wife's parents with turkey, gravy, mashed potatoes, stuffing, maple walnut sweet potato casserole, green bean casserole, bread, pumpkin and pecan pies on the menu.
412-977-3526 call/text
November 23, 2016 at 8:16 am
robert.sterbal 56890 (11/23/2016)
What is on your menu for Thanksgiving?
looks like SQL Server Central is having spam for thanksgiving :crazy:
November 23, 2016 at 8:29 am
robert.sterbal 56890 (11/23/2016)
What is on your menu for Thanksgiving?
Hopefully, some football :hehe:
November 23, 2016 at 8:30 am
Chris Harshman (11/23/2016)
robert.sterbal 56890 (11/23/2016)
What is on your menu for Thanksgiving?looks like SQL Server Central is having spam for thanksgiving :crazy:
That is on the menu every day. We don't need a holiday to get an overload of spam.
_______________________________________________________________
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/
November 23, 2016 at 8:34 am
robert.sterbal 56890 (11/23/2016)
What is on your menu for Thanksgiving?Can you share any recipes?
Our family will be having Thanksgiving at my wife's parents with turkey, gravy, mashed potatoes, stuffing, maple walnut sweet potato casserole, green bean casserole, bread, pumpkin and pecan pies on the menu.
Mostly the standard fair but I also have a second turkey for the smoker and a bacon explosion. One big difference between the one found there and mine is you will never find me putting bbq sauce on anything. For me bbq sauce is a condiment, not an ingredient. The one exception to that rule being meatloaf. And of course we can't forget my signature peanut butter pie. 😛
_______________________________________________________________
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/
November 23, 2016 at 8:53 am
Forum Update: Scheduled to begin UAT testing tomorrow (Nov 24). Some of you will likely be notified.
Viewing 15 posts - 56,761 through 56,775 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply