October 30, 2020 at 1:25 am
For those familiar with TDE, I could use a hand over here: https://www.sqlservercentral.com/forums/topic/tde-drama
I did something stupid. I'm just not sure how to unwind it.
October 30, 2020 at 2:40 pm
Steve Collins wrote:My goal is to come up with questions
Weird, the message above is not the message in the email notification...
Ha, yes I changed it a bunch of times. It doesn't seem possible to judge whether or not someone's own questions are "good" or not.
After answering SQL questions for a while I'm feeling burned out. I started on Stack Overflow in August and at first the points chase was thrilling. I answered 328 questions in 2.5 months. But along the way I started to notice patterns. Not everything is what it seems on that site. Imo nothing is what it seems on that site at least in the SQL tags. What to do about it? Idk. If this sounds mysterious then I would advise anyone interested to go find out for themselves. Someday maybe I'll revisit SO but for now I'm just sick of it.
Having questions means learning something new. For a while I've wanted to go through Solomon Rutsky's SQL CLR stairway series. That seems like a more fruitful way to spend time and enjoy my SQL experience 🙂
Congrats on the new position!! It sounds wonderful
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 30, 2020 at 2:55 pm
Someday maybe I'll revisit SO but for now I'm just sick of it.
It's funny... every once in a while, I go back for a look-see... I'm quickly reminded as to why I chose to be an infrequent participant by the questions being asked, the ignorant/arrogant comments, and some really bad answers. There's the occasional gem to be found but, for the most part, it's a well paved on-ramp to a dirt road with potholes and errant bullets flying around.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 30, 2020 at 3:01 pm
If I understand SO correctly, all they want is an answer, not necessarily the best answer. Also, don't try and have a discussion as they will shut you down.
October 30, 2020 at 3:22 pm
I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of a search engine.
Now, perhaps someone can help me. I have a database with fields, and one field has a value of "eggs, bacon, sausage", how do I get this to have 1 line for each value in the field?
/sarcasm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 30, 2020 at 3:43 pm
I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of a search engine.
Now, perhaps someone can help me. I have a database with fields, and one field has a value of "eggs, bacon, sausage", how do I get this to have 1 line for each value in the field?
/sarcasm
I almost started to answer this until I saw the /sarcasm tag you included. Of course I have been up all night since I was sleeping on and off all day yesterday.
October 30, 2020 at 3:46 pm
I almost started to answer this until I saw the /sarcasm tag you included. Of course I have been up all night since I was sleeping on and off all day yesterday.
I'm not sure if I should be pleased you're happy to help me with such a (silly) question or upset that you thought, for even a second, my question was genuine, Lynn. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 30, 2020 at 3:48 pm
Lynn Pettis wrote:I almost started to answer this until I saw the /sarcasm tag you included. Of course I have been up all night since I was sleeping on and off all day yesterday.
I'm not sure if I should be pleased you're happy to help me with such a (silly) question or upset that you thought, for even a second, my question was genuine, Lynn. 😉
Be happy, that is always the better choice.
October 30, 2020 at 3:52 pm
Now, perhaps someone can help me. I have a database with fields, and one field has a value of "eggs, bacon, sausage", how do I get this to have 1 line for each value in the field?
/sarcasm
Give me the eggs and bacon. Viola! You have sausage on a line by itself.
/NotSarcasm. YUM!
October 30, 2020 at 4:00 pm
I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of a search engine.
Now, perhaps someone can help me. I have a database with fields, and one field has a value of "eggs, bacon, sausage", how do I get this to have 1 line for each value in the field?
/sarcasm
Serious data quality problem there... You need to add biscuits and gravy modifiers for the sausage, english muffin, butter, and a side of grits, oatmeal, or cream of wheat plus 4 12 oz cups of good coffee.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 30, 2020 at 4:02 pm
Dammit... I made myself hungry typing that.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 30, 2020 at 4:15 pm
If I understand SO correctly, all they want is an answer, not necessarily the best answer. Also, don't try and have a discussion as they will shut you down.
Most of the answers aren't even right, although i have found some interesting tricks that were wrong for the actual question they answered but nifty in other places 😛
October 30, 2020 at 4:33 pm
There's the occasional gem to be found but...
In my 2.5 months there were 2 answers which stood out as real gems.
Check this out. Ben Thul posted a full working example of hierarchyid complete with .ToString(). Nice!
https://stackoverflow.com/a/63798392/6748758
Also, like many SQL devs I concatenate strings together without a thought all the time. Here's SSC's Thom A (who is Larnu on SO) with a great explanation. A variation of this was posted here on SSC I think.
https://stackoverflow.com/a/64334047/6748758
Two gems found along the dirt road with potholes and errant bullets flying around 🙂
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 30, 2020 at 4:37 pm
I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of a search engine.
Now, perhaps someone can help me. I have a database with fields, and one field has a value of "eggs, bacon, sausage", how do I get this to have 1 line for each value in the field?
/sarcasm
Trying to come up with a silly pun on green eggs and ham (I failed) by googling Seuss SQL, I did accidentally come across what appears to be a site with its pants down.
https://www.kissthisguy.com/dr-seuss-misheard-songs-lyrics-2122.htm
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
October 30, 2020 at 4:45 pm
If I understand SO correctly, all they want is an answer, not necessarily the best answer. Also, don't try and have a discussion as they will shut you down.
The very nice chat we're having here would be completely verboten! Image developers acting as human beings, it's shocking I tell you
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Viewing 15 posts - 65,221 through 65,235 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply