August 24, 2017 at 2:19 pm
Ed Wagner - Thursday, August 24, 2017 1:20 PMI think "the snowflake melted" is a very good way of putting it. For a self-proclaimed 50 year old, he sure doesn't display much maturity, does he?And Lynn, nice job on neatly wrapping up what he gets from the experience. You were so nice, I think you put a bow on it. I stayed away because I don't think I would have been as nice. Judging my the attitude displayed in his other posts, I figured it would go south eventually. Either that, or turn into SS 2.0.
Well, I don't have much faith in that he will read anything after his last comments basically telling us to blank off.
August 25, 2017 at 5:08 am
GilaMonster - Thursday, August 24, 2017 11:44 AM@Lynn
This is how he's handling transactions: https://www.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-Equal
I don't see any of his posts on that thread right now, except where you guys quoted him.
August 25, 2017 at 5:13 am
Wow. He deleted the entire TRY CATCH thread too.
I find myself wondering if he's going to find his way over to Stack Overflow and change his mind about the "vicious comments" over here.
August 25, 2017 at 5:16 am
Having a really bad morning here. Fighting a development project and trying to figure out how to do a MAX row thing while simultaneously doing a MIN row thing for another column in the same table. Then I have to number the rows by each "group ID"...
Then I suddenly remembered to actually diagram it out and it started making sense. <headdesk>. I gotta stop trying to code everything in my head first.
August 25, 2017 at 5:44 am
I just caught possibly one of the worst abominations of a query I've yet to see here...
6(!!!) NOLOCK hints scattered throughout the query (and it's not even that long,) 2 in subqueries in the where clause, 1 in the main select, and the remaining as part of the 3 LEFT OUTER JOINs...
And a MAXDOP=1 on the end (because this application is so crappily coded internally, and I suspect the database is a horrible mess, that if it goes parallel it takes ages to return, and that's with the cost threshold and maxdop both adjusted from default)
Thankfully the customer has a plan to refactor their mess of an application once we get into the new fiscal year...
August 25, 2017 at 5:52 am
jasona.work - Friday, August 25, 2017 5:44 AMThankfully the customer has a plan to refactor their mess of an application once we get into the new fiscal year...
snort.
Snicker.
BWAHAHAHAHAHA.
Sorry. It's just ... I've heard that so many times in my workplace... And you believe them?
August 25, 2017 at 5:55 am
Brandie Tarvin - Friday, August 25, 2017 5:13 AMWow. He deleted the entire TRY CATCH thread too.I find myself wondering if he's going to find his way over to Stack Overflow and change his mind about the "vicious comments" over here.
Either he went through and deleted everything, or he deleted his account and there's a cascade delete on the foreign key to the posts table, as his older threads have also been wiped:
https://www.sqlservercentral.com/Forums/1890120/Using-Print-To-Debug-Stored-Procedures
https://www.sqlservercentral.com/Forums/1888119/Using-Named-Transactions
https://www.sqlservercentral.com/Forums/1885155/Execute-Stored-Procedure-With-Output-Parameter
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
August 25, 2017 at 6:11 am
jasona.work - Friday, August 25, 2017 5:44 AMThankfully the customer has a plan to refactor their mess of an application once we get into the new fiscal year...
And the plan is 'put it off for another year, it's working fine.'
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
August 25, 2017 at 6:48 am
GilaMonster - Friday, August 25, 2017 6:11 AMjasona.work - Friday, August 25, 2017 5:44 AMThankfully the customer has a plan to refactor their mess of an application once we get into the new fiscal year...And the plan is 'put it off for another year, it's working fine.'
Actually, I'm kind of hopeful they are going to follow through and refactor. They've got awful performance problems under heavy use and they really want to get this out to a wider user-base than it can currently handle. They've tried (at the current developer recommendations) throwing hardware at the problem, which only gave limited improvement. At some point they want to collect some performance counters on the SQL side when they have a good-sized training group in, to prove it's not the SQL (which from the lack of problems from other customers sharing the server, it's not.)
Fun part is, we were all set to run the performance check a couple weeks ago, and they had to bail out on it as they weren't ready...
August 25, 2017 at 7:25 am
jonathan.crawford - Thursday, August 24, 2017 12:17 PMSteve Jones - SSC Editor - Wednesday, August 23, 2017 8:39 AMWell, one more kid gone. Moved the middle one to college yesterday and left him there.One interesting thing from me. This was his bookshelf, books he brought from home to read. Not for classes, for general interest.
Machiavelli, Russian Verbs, Dostoevsky and PYTHON!!!! Dear God, Steve.....
And econ. He was reading econ and C&P for fun this summer. Did the Python as a class in the spring .
August 25, 2017 at 7:32 am
Steve Jones - SSC Editor - Friday, August 25, 2017 7:25 AMjonathan.crawford - Thursday, August 24, 2017 12:17 PMSteve Jones - SSC Editor - Wednesday, August 23, 2017 8:39 AMWell, one more kid gone. Moved the middle one to college yesterday and left him there.One interesting thing from me. This was his bookshelf, books he brought from home to read. Not for classes, for general interest.
Machiavelli, Russian Verbs, Dostoevsky and PYTHON!!!! Dear God, Steve.....
And econ. He was reading econ and C&P for fun this summer. Did the Python as a class in the spring .
http://www.smbc-comics.com/index.php?id=2834
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 25, 2017 at 8:35 am
Brandie Tarvin - Friday, August 25, 2017 5:52 AMjasona.work - Friday, August 25, 2017 5:44 AMThankfully the customer has a plan to refactor their mess of an application once we get into the new fiscal year...snort.
Snicker.
BWAHAHAHAHAHA.
Sorry. It's just ... I've heard that so many times in my workplace... And you believe them?
Now there's the voice of experience. I'm with you because I have experience as well. 😉
August 25, 2017 at 8:40 am
Ed Wagner - Friday, August 25, 2017 8:35 AMBrandie Tarvin - Friday, August 25, 2017 5:52 AMjasona.work - Friday, August 25, 2017 5:44 AMThankfully the customer has a plan to refactor their mess of an application once we get into the new fiscal year...snort.
Snicker.
BWAHAHAHAHAHA.
Sorry. It's just ... I've heard that so many times in my workplace... And you believe them?
Now there's the voice of experience. I'm with you because I have experience as well. 😉
Do you know the difference between a pessimist and an optimist?
Experience. 😀😀😀
_______________________________________________________________
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/
August 25, 2017 at 9:03 am
Sean Lange - Friday, August 25, 2017 8:40 AMEd Wagner - Friday, August 25, 2017 8:35 AMBrandie Tarvin - Friday, August 25, 2017 5:52 AMjasona.work - Friday, August 25, 2017 5:44 AMThankfully the customer has a plan to refactor their mess of an application once we get into the new fiscal year...snort.
Snicker.
BWAHAHAHAHAHA.
Sorry. It's just ... I've heard that so many times in my workplace... And you believe them?
Now there's the voice of experience. I'm with you because I have experience as well. 😉
Do you know the difference between a pessimist and an optimist?
Experience. 😀😀😀
Hope springs eternal...
August 25, 2017 at 10:43 am
I know it's Friday, but can someone give me a hint here?
https://www.sqlservercentral.com/Forums/1893830/Delete-Extended-Events-file
Viewing 15 posts - 59,701 through 59,715 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply