January 24, 2019 at 6:32 am
<Headdesk>
You know that moment when, after 5-6 hours of unit testing (sometimes the entire previous day) and trying to find out why all your records disappeared, you realize that the new column you added and are joining on is full of NULL because you forgot to update it?
That's my morning.
On the plus side, I think I figured out my CROSS APPLY typo issue (half-typo, half-NULL column) that was screwing me up. So now I have to go back and update that thread today.
Yep. Fun fun fun fun morning.
Problem solved! Sorta. Yay?
January 24, 2019 at 7:51 am
Brandie Tarvin - Thursday, January 24, 2019 6:32 AM<Headdesk>You know that moment when, after 5-6 hours of unit testing (sometimes the entire previous day) and trying to find out why all your records disappeared, you realize that the new column you added and are joining on is full of NULL because you forgot to update it?
That's my morning.
On the plus side, I think I figured out my CROSS APPLY typo issue (half-typo, half-NULL column) that was screwing me up. So now I have to go back and update that thread today.
Yep. Fun fun fun fun morning.
Problem solved! Sorta. Yay?
That's OK. I installed a patch to my own company's software that nuked all the data in the database. The article I was ready to write is waiting at least one more day while I collect all the data... again.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
January 24, 2019 at 8:10 am
ChrisM@Work - Thursday, January 24, 2019 6:30 AMThe suspense is killing me! Someone please PM me the company name!!I know a company beginning with A that Rodney and numerous other SSC lurkers have worked for and left earlier than company A might have liked...
I cannot possibly comment 😀
But I am now slightly scared when looking for my next contract to avoid all companies starting with B!
Cheers,
Rodders...
January 24, 2019 at 8:23 am
Grant Fritchey - Thursday, January 24, 2019 7:51 AMI installed a patch to my own company's software that nuked all the data in the database.
Improving performance, the Fritchey way!
January 24, 2019 at 8:28 am
Is it too early to mention SQL Bits?
Who from the Thread are attending?
I see Grant, Hugo and Gianlucci are presenting.
I'm attending Friday and Saturday. Although I'll be there in Manchester from Thursday morning and I have to leave early Saturday.
Cheers,
Rodders...
January 24, 2019 at 8:28 am
So under the context of my current project, my boss asked me to put in some technical debt. Basic code clean up and performance enhancement of code I wrote back in 2007 and have been appending / modified on a regular basis since. The code has always been complicated from day one and my understanding of T-SQL has substantially improved since then.
In the past two weeks, I have found 3 production bugs that no one has noticed. I've improved the code to cut out 20 minutes of time on one proc, 10 minutes on another, and I'm still finding stuff that can be tweaked to improve it.
This is the same code built on "If Bertie was wearing a green tie on Sunday and it rained in China but the butterflies on Greenland were flying west, do X, but if all these are true and Susie was wearing white shoes after Labor Day, do Y."
I cannot believe how much cleanup there is to do. And that I finally have time to do it. This code embarrasses me. I'm ashamed to have written it. To give you an idea of what I was dealing with, though, there were no less than 56 scope changes over the first year of the project. And there have been another 32+ since. Not to mention bug fixes for "black holes" that new business rules accidentally introduced.
Wow... just... wow.
January 24, 2019 at 8:30 am
Brandie Tarvin - Thursday, January 24, 2019 8:28 AMSo under the context of my current project, my boss asked me to put in some technical debt. Basic code clean up and performance enhancement of code I wrote back in 2007 and have been appending / modified on a regular basis since. The code has always been complicated from day one and my understanding of T-SQL has substantially improved since then.In the past two weeks, I have found 3 production bugs that no one has noticed. I've improved the code to cut out 20 minutes of time on one proc, 10 minutes on another, and I'm still finding stuff that can be tweaked to improve it.
This is the same code built on "If Bertie was wearing a green tie on Sunday and it rained in China but the butterflies on Greenland were flying west, do X, but if all these are true and Susie was wearing white shoes after Labor Day, do Y."
I cannot believe how much cleanup there is to do. And that I finally have time to do it. This code embarrasses me. I'm ashamed to have written it. To give you an idea of what I was dealing with, though, there were no less than 56 scope changes over the first year of the project. And there have been another 32+ since. Not to mention bug fixes for "black holes" that new business rules accidentally introduced.
Wow... just... wow.
How odd. Tried to edit this post and the Update Post button wouldn't work. So I'll quote myself instead.
EDIT: I'm curious. Anyone else have a similar experience?
January 24, 2019 at 8:33 am
Brandie Tarvin - Thursday, January 24, 2019 8:28 AMSo under the context of my current project, my boss asked me to put in some technical debt. Basic code clean up and performance enhancement of code I wrote back in 2007 and have been appending / modified on a regular basis since. The code has always been complicated from day one and my understanding of T-SQL has substantially improved since then.In the past two weeks, I have found 3 production bugs that no one has noticed. I've improved the code to cut out 20 minutes of time on one proc, 10 minutes on another, and I'm still finding stuff that can be tweaked to improve it.
This is the same code built on "If Bertie was wearing a green tie on Sunday and it rained in China but the butterflies on Greenland were flying west, do X, but if all these are true and Susie was wearing white shoes after Labor Day, do Y."
I cannot believe how much cleanup there is to do. And that I finally have time to do it. This code embarrasses me. I'm ashamed to have written it. To give you an idea of what I was dealing with, though, there were no less than 56 scope changes over the first year of the project. And there have been another 32+ since. Not to mention bug fixes for "black holes" that new business rules accidentally introduced.
Wow... just... wow.
And don't forget you wrote that code about 12 years ago. Imagine if you were like so many others out there who haven't improved in 12 years. I would think doing this would be pretty cool. Definitely demonstrates how far you have come.
_______________________________________________________________
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/
January 24, 2019 at 8:37 am
rodjkidd - Thursday, January 24, 2019 8:28 AMIs it too early to mention SQL Bits?
Who from the Thread are attending?I see Grant, Hugo and Gianlucci are presenting.
I'm attending Friday and Saturday. Although I'll be there in Manchester from Thursday morning and I have to leave early Saturday.Cheers,
Rodders...
Last year I attended only the Friday, and at the last minute because of the work situation. At £400 it was pricey but there were a couple of memorable sessions - most notably Brent Ozar, who was brilliant. I haven't yet seen a menu for this year but I kinda have to go for at least a part of it 'cos my daughter lives in Manchester.
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
January 24, 2019 at 8:38 am
rodjkidd - Thursday, January 24, 2019 8:28 AMIs it too early to mention SQL Bits?
Who from the Thread are attending?I see Grant, Hugo and Gianlucci are presenting.
I'm attending Friday and Saturday. Although I'll be there in Manchester from Thursday morning and I have to leave early Saturday.Cheers,
Rodders...
Rodders
It's never too early! I'm going - this will be the first time I'll have been to all four days. I don't think we've ever met, although I believe I was standing around when you had the picture for your avatar taken. There's usually a quiz on the Thursday night - perhaps I'll see you there?
John
January 24, 2019 at 8:59 am
John Mitchell-245523 - Thursday, January 24, 2019 8:38 AMRoddersIt's never too early! I'm going - this will be the first time I'll have been to all four days. I don't think we've ever met, although I believe I was standing around when you had the picture for your avatar taken. There's usually a quiz on the Thursday night - perhaps I'll see you there?
John
I'll be there on the Saturday at least. There's no excuse when it's a bus ride away
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 24, 2019 at 9:04 am
Chris, well that sounds like a good excuse as any to me! Sadly the only memorable things to me about last years event were not the sessions.
Oh and going book shopping and having dinner with Gail Saturday night in Chinatown, and having JRJ jump on the tube going back as the same carriage as us!
John - yes, as far as I know the traditional Thursday night quiz is on and I shall be there. Will be good to meet you in person.
Neil - good stuff!
Cheers,
Rodders...
January 24, 2019 at 9:10 am
Neil Burton - Thursday, January 24, 2019 8:59 AMI'll be there on the Saturday at least. There's no excuse when it's a bus ride away
Sorry, missing again. Timing doesn't work for me.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 24, 2019 at 9:13 am
Oh there is an agenda up.
Looks like Thursday and Friday is incomplete though.
Rodders...
January 24, 2019 at 10:03 am
Steve Jones - SSC Editor - Thursday, January 24, 2019 9:10 AMNeil Burton - Thursday, January 24, 2019 8:59 AMI'll be there on the Saturday at least. There's no excuse when it's a bus ride awaySorry, missing again. Timing doesn't work for me.
I'm going. Taking in the Manchester City match on Wednesday night, teaching a precon on Thursday (which means minimal imbibing during the game), and a regular session on Friday.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 15 posts - 63,016 through 63,030 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply