August 24, 2017 at 8:14 am
Ed Wagner - Tuesday, June 20, 2017 10:04 AMSean Lange - Tuesday, June 20, 2017 9:35 AMI just nearly spit out my coffee laughing. I was looking at a table built by some consultants for a project a few years ago. This is a product table and there are two columns for the product description. This is because we want a full description and a brief description that could be used as a preview. The funny part is this.
BriefDescription VARCHAR(MAX) NOT NULLKeep it brief marketing folks. As long as it is under 2GB we should be good. :w00t:
Heh - if that's the brief description, I don't want to know what the detailed description looks like. 😛
This was good enough it needs to be revived!
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, 2017 at 8:26 am
SQLRNNR - Thursday, August 24, 2017 8:14 AMEd Wagner - Tuesday, June 20, 2017 10:04 AMSean Lange - Tuesday, June 20, 2017 9:35 AMI just nearly spit out my coffee laughing. I was looking at a table built by some consultants for a project a few years ago. This is a product table and there are two columns for the product description. This is because we want a full description and a brief description that could be used as a preview. The funny part is this.
BriefDescription VARCHAR(MAX) NOT NULLKeep it brief marketing folks. As long as it is under 2GB we should be good. :w00t:
Heh - if that's the brief description, I don't want to know what the detailed description looks like. 😛
This was good enough it needs to be revived!
LOL. I had forgotten about this. It is really only one of dozens of things in this database where you just scratch your head and wonder...
_______________________________________________________________
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 24, 2017 at 8:33 am
Sean Lange - Thursday, August 24, 2017 8:26 AMSQLRNNR - Thursday, August 24, 2017 8:14 AMEd Wagner - Tuesday, June 20, 2017 10:04 AMSean Lange - Tuesday, June 20, 2017 9:35 AMI just nearly spit out my coffee laughing. I was looking at a table built by some consultants for a project a few years ago. This is a product table and there are two columns for the product description. This is because we want a full description and a brief description that could be used as a preview. The funny part is this.
BriefDescription VARCHAR(MAX) NOT NULLKeep it brief marketing folks. As long as it is under 2GB we should be good. :w00t:
Heh - if that's the brief description, I don't want to know what the detailed description looks like. 😛
This was good enough it needs to be revived!
LOL. I had forgotten about this. It is really only one of dozens of things in this database where you just scratch your head and wonder...
This is proof that even the weirdest design decisions aren't completely useless. If nothing else, they can serve as an example of what no to do...or just give others a good laugh.
August 24, 2017 at 8:36 am
SQLRNNR - Thursday, August 24, 2017 8:07 AMSean Lange - Monday, August 21, 2017 1:42 PMGilaMonster - Monday, August 21, 2017 1:40 PMSean Lange - Monday, August 21, 2017 1:26 PMWe were able to catch a few glimpses at about 30-35% but before it got even close to full we couldn't see anything for the storms rolling in. It was very creepy though how dark it got. All was not lost as I was able to experience how the darkness rolled in. And the actual eclipse part was much as I remembered it as a kid in grade school in the 70s. Hopefully in another 7 years I will be able to travel to view the totality (and it won't be cloudy).I'm eying 2026 in Iceland. August, so possibility of eclipse and northern lights in one trip 🙂
That, or 2030 when the path of totality goes 270km south of Johannesburg.I saw the full eclipse in 2002, spectacular!
Northern lights are truly amazing. We could see them occasionally when I lived in Seattle but the year I lived in Alaska we got to see them quite frequently. I like the idea of Iceland in 2026. Would really like to visit there someday anyway so why not do it during a great time!!!
I enjoyed the lights in Alaska when I lived there. It was cool.
When and where did you live there? I was outside Palmer in the mountains near Hatcher Pass. I was there from about April 88 - March 89.
_______________________________________________________________
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 24, 2017 at 11:28 am
Ugh, with how tight things get locked down at work, and how crappy the network can be (even worse when working from home,) is it sad that part of me wants to try to figure out how to pass queries through SSRS to my SQL Servers?
And yes, I realize this is a truly awful, horrible, terrible, insanely insecure idea...
August 24, 2017 at 11:40 am
jasona.work - Thursday, August 24, 2017 11:28 AMUgh, with how tight things get locked down at work, and how crappy the network can be (even worse when working from home,) is it sad that part of me wants to try to figure out how to pass queries through SSRS to my SQL Servers?
And yes, I realize this is a truly awful, horrible, terrible, insanely insecure idea...
Remember when you could send email to SQL Server and have it run queries?
August 24, 2017 at 11:45 am
@Lynn
This is how he's handling transactions: https://qa.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-Equal
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 24, 2017 at 12:15 pm
GilaMonster - Thursday, August 24, 2017 11:44 AM@Lynn
This is how he's handling transactions: https://qa.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-Equal
Charming...
August 24, 2017 at 12:16 pm
GilaMonster - Thursday, August 24, 2017 11:44 AM@Lynn
This is how he's handling transactions: https://qa.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-Equal
I did see that, thanks.
It's all good, the snowflake melted.
August 24, 2017 at 12:17 pm
Steve 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.....
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 24, 2017 at 12:39 pm
Lynn Pettis - Thursday, August 24, 2017 12:16 PMGilaMonster - Thursday, August 24, 2017 11:44 AM@Lynn
This is how he's handling transactions: https://qa.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-EqualI did see that, thanks.
It's all good, the snowflake melted.
Yeah no loss as far I am concerned. Interesting how he states he has no experience at one point and another feels he needs to knock his ring on the table about being 50 and having multiple degrees in IT. Which one is it?
_______________________________________________________________
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 24, 2017 at 12:51 pm
Sean Lange - Thursday, August 24, 2017 12:39 PMLynn Pettis - Thursday, August 24, 2017 12:16 PMGilaMonster - Thursday, August 24, 2017 11:44 AM@Lynn
This is how he's handling transactions: https://qa.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-EqualI did see that, thanks.
It's all good, the snowflake melted.
Yeah no loss as far I am concerned. Interesting how he states he has no experience at one point and another feels he needs to knock his ring on the table about being 50 and having multiple degrees in IT. Which one is it?
Obviously all he wanted was affirmation not help.
August 24, 2017 at 1:04 pm
Lynn Pettis - Thursday, August 24, 2017 12:51 PMSean Lange - Thursday, August 24, 2017 12:39 PMLynn Pettis - Thursday, August 24, 2017 12:16 PMGilaMonster - Thursday, August 24, 2017 11:44 AM@Lynn
This is how he's handling transactions: https://qa.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-EqualI did see that, thanks.
It's all good, the snowflake melted.
Yeah no loss as far I am concerned. Interesting how he states he has no experience at one point and another feels he needs to knock his ring on the table about being 50 and having multiple degrees in IT. Which one is it?
Obviously all he wanted was affirmation not help.
Sadly in my first response I stated the format of his error handling block look reasonable. Maybe if I had said that first and then mentioned that his code resembles my wife's favorite dish at Olive Garden he would have felt less offended. Just like you, I would have said the same thing in person. I didn't think my comment was rude, belittling or ego stroking.
_______________________________________________________________
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 24, 2017 at 1:08 pm
Sean Lange - Thursday, August 24, 2017 1:04 PMSadly in my first response I stated the format of his error handling block look reasonable. Maybe if I had said that first and then mentioned that his code resembles my wife's favorite dish at Olive Garden he would have felt less offended.
Probably not, because he took a long explanation of how transactions work as an accusation, before posting the same code asking about try catch blocks
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 24, 2017 at 1:20 pm
I 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.
Viewing 15 posts - 59,686 through 59,700 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply