2021.09.16 18:32 Drippinn You can now trade SHIB on coinbase!
|submitted by Drippinn to SHIBArmy [link] [comments]|
2021.09.16 18:32 jpat1975 📊 Artist Coonception - Lebreton Flats Phase 99
|submitted by jpat1975 to OttawaRaccoons [link] [comments]|
2021.09.16 18:32 Economy_Passenger_80 (Question) Hughes and Kettner Grandmeister 36 issue
To anyone who knows about and/or owns a Grandmeister 36 amp. My band and I were playing at a wedding last week, we were outside on a stage but all the band's power (pa, amps and full light set up) had to come from one lead running from a generator. Throughout the gig whenever our sunstrip lights came on full beam my amp would stop making sound, all the lights were on but no-one was home. Turning the amp off and then on again seemed to resolve the issue temporarily, until the sunstrips went off again. My question, is was this just down to the generator messing with our power and setting off some kind of surge protector built into the amp to protect itself, or is this some other issue that other people have encountered in different situations, which needs fixing? Any advice would be much appreciated, thanks
submitted by Economy_Passenger_80 to GuitarAmps [link] [comments]
2021.09.16 18:32 OberonPrimeGX Galarian Zapdos
If one team is getting massively stomped on, Zapdos pops as its Galarian form and runs away from the winning team to get killed on purpose by the losing team in front of their spawn gate.
Defeating it instantly teleports players to active enemy goals and presses the X button for you.
Then the game makes you a sandwich.
submitted by OberonPrimeGX to PokemonUnite [link] [comments]
2021.09.16 18:32 Echinometra @jessicafitbunny
|submitted by Echinometra to classywhitegirls [link] [comments]|
2021.09.16 18:32 ldmomma25 Today is Astras, *one month home* day, and we've loved every second of it ❤
|submitted by ldmomma25 to Rabbits [link] [comments]|
2021.09.16 18:32 esmus1 Kayıt kalitesi için kusura bakmayın
|submitted by esmus1 to gitarr [link] [comments]|
2021.09.16 18:32 DoobieJam Caught my coworker off guard
Me: I just really want to quit my job and then stretch my savings for as long as I can and then the day I run out of money I’ll just…
CW: Ask to come back?
Me: Well, I was gonna say go out in the backyard and shoot myself in the face so there’s less mess for people to clean up, but I guess yours is a good idea too
submitted by DoobieJam to depression_memes [link] [comments]
2021.09.16 18:32 Otherwise-Farm-3025 Hola! Necesito su ayuda para una investigación
Si hubiera una app con estas características, ¿Cuánto pagarían?
2021.09.16 18:32 AllCouponFree Facebook Ads 101. Complete Facebook Ads
2021.09.16 18:32 TOTeM12345 Stay organized with project and task management tools
2021.09.16 18:32 HappyDragon24 Can I use contact cleaner to clean MAF?
Hello, I think my MAF sensor needs to be cleaned and I couldn’t find MAF cleaner, can I use contact cleaner?
From what I heard brake cleaner and WD-40 are not good for the job.
Thank you for reading!!!
submitted by HappyDragon24 to Cartalk [link] [comments]
2021.09.16 18:32 CRQueueofficial Blue Digit and Markiplier sure were nice!
|submitted by CRQueueofficial to Markiplier [link] [comments]|
2021.09.16 18:32 oMrEnigma When did I need to play for the Renewal Egg?
I've been setting aside arena till Innistrad released and I'm positive I've played at least one game this set. But I don't have the renewal egg in my profile.
submitted by oMrEnigma to MagicArena [link] [comments]
2021.09.16 18:32 rooster_eggs Seeking Pointers on Optimizing a Query
Hi everyone. I'd like to preface this by saying I'm not here seeking for someone to rewrite a query for me. Rather, I'm hoping that based on what I'm presenting, I can be provided with some general pointers on how to optimize this query, best practices, or concepts to look into. I have not had to use SQL for several years, so my knowledge of the language is rusty and I am interested in familiarizing myself with it more.
I've inherited a project at work that contains a SQL query (shown below) that takes nearly three hours to run. At first glance this query seems messy and sub-optimal.
I completely accept that it is possible that due to the structure of the database(s) involved and the amount of data, that duration is just something we can't get around. Or that the query is already optimal and nothing can be done. But due to the frequency that this application is used, ideally we would like to speed up this process. If this can be achieved by approaching this query differently, that would be ideal.
The general description is that we want to retrieve records from the last 5 years that are of a specific document type and have certain descriptors. Additionally, we want to only retrieve the latest record of that specific document.
I've included the query below (with some changes to variable or attribute names for privacy). I was wondering if anyone had any general pointers on how to best start going about trying to revise this query. For example:
submitted by rooster_eggs to SQL [link] [comments]
SELECT CAST(CAST(dm.[DOCNUM] as bigint) as nvarchar(20)) +'.'+CAST(CAST(dm.[VERSION] as bigint) as nvarchar(20)) as [Unique_Doc.Version_ID] ,dm.[DOCNUM] ,dm.[VERSION] ,dm.[DOCNAME] ,dm.[DOCSIZE] ,dm.[DOCLOC] as [DocLocation] ,dm.[ENTRYWHEN] ,SUBSTRING(dm.[DOCLOC],0,CHARINDEX(':',dm.[DOCLOC])) as [DocServer] ,dserv.[ROOTPATH] as [ServerRootPath] ,right(replace(dm.[DOCLOC], '\' + right(dm.[DOCLOC], charindex('\', reverse(dm.[DOCLOC])) - 1), ''), charindex('\', reverse(replace(dm.[DOCLOC], '\' + right(dm.[DOCLOC], charindex('\', reverse(dm.[DOCLOC])) - 1), ''))) - 1) as [DocServerFolder] ,dserv.[LOCATION] as [ServerLocation] ,dm.[T_ALIAS] as [FileFormat] ,dclass.[CLASSDESCRIPT] as [FileType] ,dm.[C1ALIAS] as [Customer#] ,dm.[C2ALIAS] as [Issue#] ,dm.[C1ALIAS] +'.'+ dm.[C2ALIAS] as [Custom/Issue#] ,dm.[C30ALIAS] as [RoleCode] FROM [COMPANY_NAME].[MHGROUP].[DOCMASTER] dm -- Get latest version of documents INNER JOIN ( SELECT dm.[DOCNUM] ,MAX(dm.[VERSION]) AS 'Latest Version' FROM [COMPANY_NAME].[MHGROUP].[DOCMASTER] dm LEFT JOIN [COMPANY_NAME].[MHGROUP].[DOCCLASSES] dclass on dm.[C_ALIAS] = dclass.[C_ALIAS] INNER JOIN [COMPANY_NAME].[MHGROUP].[DOCSERVERS] dserv on SUBSTRING(dm.[DOCLOC],0,CHARINDEX(':',dm.[DOCLOC])) = dserv.[DOCSERVER] WHERE DATEDIFF(yy, dm.[ENTRYWHEN], GETDATE()) <= 5 -- past 5 years AND dm.[T_ALIAS] IN ('ACROBAT', 'WORD', 'WORDX') AND dclass.[CLASSDESCRIPT] IN ('Item Document', 'IMO Documents', 'Identification', 'Office', 'General', 'Request', 'Pre-Process Documents', 'Post-Process Documents') AND dserv.[ROOTPATH] = '\COMPANY_NAME' GROUP BY dm.[DOCNUM] ) AS subquery ON dm.[DOCNUM] = subquery.[DOCNUM] AND dm.[VERSION] = subquery.[Latest Version] LEFT JOIN [COMPANY_NAME].[MHGROUP].[DOCCLASSES] dclass on dm.[C_ALIAS] = dclass.[C_ALIAS] INNER JOIN [COMPANY_NAME].[MHGROUP].[DOCSERVERS] dserv on SUBSTRING(dm.[DOCLOC],0,CHARINDEX(':',dm.[DOCLOC])) = dserv.[DOCSERVER] WHERE DATEDIFF(yy, dm.[ENTRYWHEN], GETDATE()) <= 5 -- past 5 years AND dm.[T_ALIAS] IN ('ACROBAT', 'WORD', 'WORDX') AND dclass.[CLASSDESCRIPT] IN (''Item Document', 'IMO Documents', 'Identification', 'Office', 'General', 'Request', 'Pre-Process Documents', 'Post-Process Documents') AND dserv.[ROOTPATH] = '\COMPANY_NAME' GROUP BY dm.[DOCNUM] ,dm.[DOCNAME] ,dm.[DOCSIZE] ,dserv.[ROOTPATH] ,dserv.[LOCATION] ,dm.[VERSION] ,dm.[C1ALIAS] ,dm.[C2ALIAS] ,dm.[DOCLOC] ,dm.[ENTRYWHEN] ,dm.[T_ALIAS] ,dm.[C30ALIAS] ,dclass.[CLASSDESCRIPT] ORDER BY dm.[C2ALIAS] ,dm.[DOCNUM];
2021.09.16 18:32 luketheduke03 Check out my Rayo Vallecano team, three seasons in and already challenging for European football
|submitted by luketheduke03 to seriousfifacareers [link] [comments]|
2021.09.16 18:32 AllCouponFree Facebook Ads 101. Complete Facebook Ads
2021.09.16 18:32 edutreasure TE0-125 Teradata 12 Solutions Development Practice Test udemy coupon
|submitted by edutreasure to udemyfreebies [link] [comments]|
2021.09.16 18:32 tonywei1992 Ni No Kuni II: Revenant Kingdom Switch Port Review
|submitted by tonywei1992 to JRPG [link] [comments]|
2021.09.16 18:32 Fuzzy-Serve Piers Morgan hired to launch Rupert Murdoch TV station talkTV | News UK
|submitted by Fuzzy-Serve to unitedkingdom [link] [comments]|
2021.09.16 18:32 BareeBeeBeenson Most searched porn categories by state in an alternate (better?) universe
|submitted by BareeBeeBeenson to mapporncirclejerk [link] [comments]|
2021.09.16 18:32 mayb-ur-rit Man in Egypt lets street cats eat freely from the dry food he sells
|submitted by mayb-ur-rit to HumansBeingBros [link] [comments]|
2021.09.16 18:32 reddit_feed_bot TheBlaze: Couch: USC likely regrets failing to hire Urban Meyer two years ago
|submitted by reddit_feed_bot to TheNewsFeed [link] [comments]|
2021.09.16 18:32 JhiJosh Ps4 93 ovr playshot need a center for 2s idc about ovr or rep or win % just have badges
2021.09.16 18:32 AstronASMR Am I going crazy or does my family not care about me at all?
I (17m) think my family doesn't care about me. Like if I ended myself they wouldn't even care. I want to know if this makes sense or if the things are just coincidences.
I have dreaded school my whole life and my parents definitely know. Here are some vivid memories I have of my parents seeing that:
Since elementary school I have cried if I had to go to school. In second grade (8 years old), I broke down over not being able to make a paint butterfly. I cried because I didn't have my homework (even though I actually had it, just erased it because the teacher would get mad at us if we had done something we weren't supposed to -and my classmates told me that I had done too much). My mother, seeing this took me to the teacher, she (the teacher) told me to just not be stressed and I cried.
When I was 13 my father caught me do Italian homework at 4 am in the morning. He just said that he thinks it would be good if I generally slept enough.
Also when I was 13 my parents found a note that I want to end myself and in the same year they saw me break down on the week-end, sobbing on the floor.
I obviously have some problem with school or stress or high expectations ( I was in the gifted program with 2 others in my grade, both of which dropped out), I was self-conscious about my intelligence and wanted to prove that I was smart, so when my parents asked me to do an IQ test for whatever reason and I said yes (I also borrowed a bunch of IQ testing books from my father). I did the test and I remember how the psychologist there said something like "It might not be what you wanted but it's 124". I almost cried. At the same institution, I was sent to a therapist (because of the note, I guess, but I didn't know about that, I thought I was just there for the IQ test). I felt betrayed or tricked by my parents and so I hated the therapist there. I at first pretended everything was fine but started to cry and when she asked I told her I was thinking of ending myself. She told my parents and that I have depression. I went to the school counselor and like three other therapists, never for longer than one session. They were garbage. They told me to do more sport or "just not worry about grades that much".
I switched schools (to a boarding school) and I guess my parents just forgot? I was still depressed, everyone (my acquaintances anyway) knew about it at my school, too, but literally more people were depressed than not (I am not kidding), so noone cared. I evaded grades for 3 months by going on an exchange to France (I'm German). (My mental health was even worse there by the way). But when I came back I couldn't take it at my school anymore and told my mother I wanted therapy. She asked me if I didn't rather want a "life coach", obviously not. My mom wanted me to go through the school counselor even though I told her I didn't want her. I was there only once and hated it. I told her "I am often sad" and apparently she took that as just that I was unhappy (I didn't want to say I was depressed because I didn't want to "fake it" or whatever). I switched schools back to my old school shortly thereafter.
My parents know I absolutely hate school, like in the holidays they ask me if "I'm already dreading school" and I say yes.
This might be out of place (but it's chronologically next): When my grandmother died, the mother of my father, I felt like nobody cared. She literally only had me, my brother and my parents as family and I felt like none of us cared. In the morning (when I heard), I thought they cared, so I pretended to as well. But later that day, my parents just said whatever they heard other people say about close family members. At the day of her death and the funeral, to them it was more like any other day. Just that now it was appropriate to seem sad. She was realistically always more of a burden than anything else, I don't think anyone in my family liked being around her and caring for her was obviously work (she was in a home in her last years, because my parents didn't want her living with us)
When my other grandmother had died, my father also just announced it just like the fact that our week-end plans were canceled or something.
So, now to the recent event that lead me to write this post and think about all of this. I hate birthdays, I haven't celebrated them in a special way since I was a child. For this year, I just wanted to use the say I had on that day to eat my favorite food and watch a movie at home. I knew that if there was something special going on, I would get really sad. I always weep before, when private during, and after my birthdays. Maybe because I missed the opportunity or something. Anyways, I hate birthdays and told my parents specifically many times that I didn't want ANY presents. I made sure that they understood that it was not that I didn't think of anything but that I don't WANT presents.
They got me the biggest birthday gifts I have ever gotten (plus some others). I didn't expect it at all and felt soo shitty. They purposefully disregarded my easy-to-fulfill wish and now I have to pretend to be happy over presents I didn't want. The two big gifts were a new phone and a trip to Liechtenstein. The trip to Liechtenstein was with my father and included a helicopter ride and fine dining, ...
I really enjoyed Liechtenstein (although I always had in the back of my mind that I didn't ask for this) until my father, on the way to the helicopter told me: "Don't forget to take photos with your phone, I think they should be really good :)" I told him I didn't bring my phone (I don't like taking photos at all, don't want photos of me and didn't need my phone). He asked: "(he was surprised)Did you forget it or leave it on purpose?". I told him it was on purpose.
In that moment I realized (although I'm still not sure if this is crazy or if I'm right (hence why I'm asking this)), he just gifted me the trip so I could come along to take photos for him with my phone. My father loves fine dining and has never been on a helicopter trip and was REALLY into it. I felt so used. My father loves travelling and used to be able to go on business trips but he his company went broke and now can't do that as much where he works.
One time my father asked us where we wanted to go for the summer holidays (next year) or like which places we wanted to visit sometime. He proposed Albania and obviously me and my brother weren't into it. After we both said we didn't want that (thinking it was Albania or the US or Taiwan or something), he decided he REALLY wanted to go to Albania. Conveniently, we had just said that we didn't like it there so he had an excuse to fly alone.
He had previously also tried to minimize the number of people he has to travel with: He flew to Mallorca with only my brother and with me to only Sylt. Or travelled with me alone to a really expensive or castle or with my mother to India. Recently my grandfather (from my mother's side) asked my mother to come on a trip somewhere (don't know the destination) and my father snuck himself in there. My father doesn't even like my grandfather and it was supposed to be a travel with my grandfather and mother (since he is probably going to die soon). He has done this before, too.
The thing with the gifts sounds crazy, right? But I have lost all respect for my father. And I don't think my mother cares about me either.
The grandfather that is still alive is a huge dick to literally everyone. He always insults me, tells me my grades are not good enough and even hit me once (illegal in Germany). I have cried so many times in front of my parents because of him but they just don't care. I have told them many times I don't want to see him ever. Still, everytime we vaguely drive into his direction, we always make a stop at his house and I dread it.
My parents both had mental disorders, my mother had anorexia and my father some anxiety thing. My brother also has some mental stuff going on. I obviously have some mental problems, too. I can't help but feel like my family doesn't care about me. And I don't care about ANYTHING. Not about my family, not about my cat (I treat her well though), I don't have ANY friends and I hate school. I don't care about studying something or getting a job or hobbies or anything. I hate all of this.
submitted by AstronASMR to Advice [link] [comments]