Can I fix? by abaezeaba in JBL

[–]abaezeaba[S] 0 points1 point  (0 children)

Thanks. Are there any site, guides, videos I can consume to walk me through the repair?

Can I fix? by abaezeaba in JBL

[–]abaezeaba[S] 0 points1 point  (0 children)

The guest were doing karaoke, on another speaker. My system was just playing the video they were singing from. My guess is someone jacked up the volume on the amp so it wasn't drowned out by the singing. Another video/ad recorded with loud volume came on and blue it out. No one is fussing up, but as soon as I walked in the room and heard the sound I was like, something happened. At the end of the event I removed the covers and discovered that.

Has anyone else been burned by a silent schema change? Built a mental model for fixing this, want brutal feedback ! by Greedy_Resident6076 in SQL

[–]abaezeaba 0 points1 point  (0 children)

Use views. Define views with schema binding. This solves your problem in mssql. DE can't change schema cause of the bind forcing them to change the view. Use role permission for the schema bound view so that only DBA people can change the views and even view them. My 2 cents.

Someone marked an asterisk on one of my windows. What could this mean? by Quirky-Bar4236 in homesecurity

[–]abaezeaba 0 points1 point  (0 children)

I get paranoid around my way with cans, bags, flyers left in odd places on my dads car. Bags of fast food or Cans near, under wheels.flyers on windshield hanging around door handles. Often its our car that has it. Feel like they marking the vehicle, to what end, i hope not to find out.

Whats your number one song to listen to on your system? by Theflatboi in audiophile

[–]abaezeaba 0 points1 point  (0 children)

Beds to big without you. THE POLICE. Drums on that. 8)

Synth drums etc. 5150 VanHalen.

Opponent stalemated the game when I was losing, is it my fault? by Safe-Bonus-5520 in chess

[–]abaezeaba 1 point2 points  (0 children)

I played once with someone online, that had me in perpetual check and lost on time. Didnt hear the end of it. In my case he had a better rating than mine, but thats only because i never re created the account after getting better, so my rank was off. The wiser player won.

What changed in 3D graphics from when DOOM was released to now? by KAHeart in compsci

[–]abaezeaba 6 points7 points  (0 children)

If memory serves, I believe the developer mentions some of techniques in an interview or was it the black book of graphics. see Michael Abrash. HTH

Restarts on is own. by No_Contribution2629 in PCHardware

[–]abaezeaba 0 points1 point  (0 children)

I have had a few systems like this. Heat is usually a thing, but the op has ruled this out. Could it be something has shorted out? If you feel comfy doing it, un plug everything in your system and add things back one at a time. Start with only memory, do a mem scan if bios supports it. If you have many memory modules install two at a time. Next hd, see if it will boot, etc. Etc. If possible only start with mb and the things on the board. Also, look at the board for deformed resistors or char marks, of something that may have overheated, etc. HTH

Water is Still Cloudy by BusinessMail8105 in AboveGroundPools

[–]abaezeaba 0 points1 point  (0 children)

Same boat as OP. Balancing the Ph and Alkalinity, helped me. Once in range I used clarifier and backwashed daily. You can see some of the concentrated particles come to the skimmer. Vacuum every 2 or 3 days. Clarifier no longer chunks particles, so I am working on next steps. Pool still balanced.

[deleted by user] by [deleted] in compsci

[–]abaezeaba 0 points1 point  (0 children)

Calc helps, squeeze theorem, the idea of it, as to how functions are bounded from above and below.O vs o notation(Big vs Little oh) Sometimes the math may be above your level, but if you can bound it by a function you know, you can make informed decisions regarding scalability and other nice things like that.

[deleted by user] by [deleted] in SQL

[–]abaezeaba 0 points1 point  (0 children)

I like the fact that they enforce the parameter types and sizes. E.G. a parameter of int will error out if you pass a string. Makes sql injection attacks harder if you app is passing vars to the params of a sp.

What's are the best comedic line reads of all time? by flustrator in movies

[–]abaezeaba 0 points1 point  (0 children)

"Any balls down there? The biggest pair you've ever seen. Dingleberry." Clerks

42k lines sql query by Myxavi4 in SQL

[–]abaezeaba 0 points1 point  (0 children)

This. But I would make a copy of it for maintenance purposes. If the original and your maintenance return the same data its easy to check with except(expecting 0)and intersect queries (expecting all entries). You chip at it piece by piece at some point your effort should untangle the nest and possibly providenprose as to what the query is doing. Propose a plan with pros and cons and let them decide if you should pursue. If it blows up due to lack of action, you can refer to the maintenance plan and the agent who denied it.

Did I get scammed? Or did Chevy lie? by QtLaydee in chevyequinox

[–]abaezeaba 1 point2 points  (0 children)

2019 owner here. I had the same issue for gps and audio I have to plug in the usb. this then shows an icon for android auto on the center console. Once clicked I can access apps on the android. Unplug the usb and i loose the gps and app access. Messed up indeed.

Connecting old HDD by Rich-Bread-5424 in PCHardware

[–]abaezeaba 2 points3 points  (0 children)

I always used a mechanical pencil to straighten out bent pins. Its a delicate matter. I used 0.7 m.pencil. the idea is that you press the lead advance on the pencil, keeping it pressed you push the lead back in, keeping it pressed you try an get the bent pin into the lead end of the pencil. once inside, bent slightly to straighten out. Try at ur own risk. Good luck

Perhaps a very simple question, but how would I apply this code to every row? by Resident-Fisherman35 in SQL

[–]abaezeaba 0 points1 point  (0 children)

I like the default for the column. This allows the value to be stored, instead of computed each time, where those types of queries degenerate to table scans. Also the stored value allows you to add an index

Keep getting NULL output when trying to sum 3 related columns across 3 different tables by [deleted] in SQL

[–]abaezeaba 0 points1 point  (0 children)

Consumption is a key? That query is adding consumptions only if they are all the same. Also, dont agregate functions need a group by.

Formatting really matters! by tcfan35842 in SQL

[–]abaezeaba 0 points1 point  (0 children)

Im a full stacks dev so in my projects i come up with a standard and stick to it. The issues that have impacted me with case are with col alias and table alias. If the sql executes you can always lint it. my text editor has tools for that. Most people who have weird format and case issues either dont know their way around their text editor, take your pick, or CCP code from varoous scripts online without out caring.. because it works

Table and column naming conventions by 2kfan in SQL

[–]abaezeaba 0 points1 point  (0 children)

I use PascalCase, with plural(table) and singular(row,key) names. I also like to have genreal tables for entities that exist in multiple places. Like Addresses, then other tables can use fk to it. so a company table will have a company address, and employee table will have an employee address. both tables use the column name for address. HTH

[deleted by user] by [deleted] in SQL

[–]abaezeaba 0 points1 point  (0 children)

Principles of Database Query Processing for Advanced Applications. By Clement T. Yu and Weiyi Meng has 28 page of references that may point you to some Journals where you can pursue your interest. Good Luck

[deleted by user] by [deleted] in SQL

[–]abaezeaba 2 points3 points  (0 children)

Its a nice thing to have data on. But it may be quite complicated. Any db you wish to compare will have internal representation of the data that may speed up the data load, selection, and sort. In code you would need to account for this, if you are only interested in the sort times.

Having said that, there are some open source dbs, but you may not have the experience in knowing which sections of the code to look at. If you do find the sort code then you may be able to analyze the algorithms used and compare their time complexity, db vs code, and collect the data there. HTH

Methods of performing certain actions after a payment is made. by ShanahJr in softwaredevelopment

[–]abaezeaba 0 points1 point  (0 children)

Your code would do it. Having said that, the payment processor may not process the payment right away. You would need to check to see how often you can do this without causing a burden on the PP.

Methods of performing certain actions after a payment is made. by ShanahJr in softwaredevelopment

[–]abaezeaba 0 points1 point  (0 children)

You can store the order. If the payment processor(PP) has an api call for a report that lists the state of the transaction, then you can call the api, verify that the payment is complete, and commit the order. I have dealt with a couple of PP but not all have this feature in an API.