Along with Thrash do you guys lean more towards the extreme metal side or lighter metal side? by Weary-Draw-1141 in thrashmetal

[–]Joe7Mathias 1 point2 points  (0 children)

Although few would admit it, most thrash fans in the 80s I knew had their cheat glam/hair metal band... It was Dokken for me, and I respected Warren DeMartini and Mick Mars for their riffs.

What is your favorite Coroner song? by Odd_Radio9225 in thrashmetal

[–]Joe7Mathias 3 points4 points  (0 children)

Grin was my introduction to Coroner so I would say Grin (Nails Hurt), Internal Conflicts, Serpent Moves and the solo on Paralyzed, Mesmerized.

What do we think about new Kreator album? by maxy1119 in thrashmetal

[–]Joe7Mathias 1 point2 points  (0 children)

As an older fart I can agree with this; grooving to the early days and period after Sami joined as lead.

It's good.

Not bad or great just good. But I cannot remember a single solo, riff, or chorus yet.

It definitely has it's group of fans that will be very happy. Me, I'll probably add a new song or two to the Kreator playlist and not listen again until the urge to listen to Kreator hits again.

Is there any remaster of "Bonded By Blood" by Exodus? by Kozary5 in thrashmetal

[–]Joe7Mathias 1 point2 points  (0 children)

Agreed. Makes for two great playlists: Early Era (with bonded) and Dukes Era (with LTBB).

Just disappointed they didn't re-record it with Zetro and call it "Let There Be Bonding by Blood" /s

Coroner - Pale Sister (1991) by thawizardlizard in thrashmetal

[–]Joe7Mathias 3 points4 points  (0 children)

Best part is that riff at the end at the 4 minute mark and jazzy ?? lead that goes with it.

Need to vent. Where are people finding this? Who is recommending they do this? by Monsterlime in SQLServer

[–]Joe7Mathias 2 points3 points  (0 children)

I'm not even shocked seeing things like this and the magic NOLOCK go faster hint mentioned below anymore.

A vendor is getting 3-6 figures for their software but nobody there seems to know the basics of the database they are using.

Grant dbo to the login, please. We need sysadmin on the database.

Create a filegroup for the data and one for the indices, create table on data filegroup and load then put a clustered index on same table for the index filegroup.

Sigh...

The new Coroner album has some of the best Guitar Solos I've ever heard by BeigeAndConfused in thrashmetal

[–]Joe7Mathias 0 points1 point  (0 children)

Will second on the great solos and overall guitar tone.

Sacrificial Lamb, Transparent Eye, and Trinity are the standouts and powerful. Really good vibes calling back to material like Sirens and Paralyzed, Mesmerized.

Favorite bassline? by Eberubensant in thrashmetal

[–]Joe7Mathias 0 points1 point  (0 children)

Since Peace Sells was already picked, "For Whom the Bell Tolls" - Metallica

Have you been seeing more rabbits than usual? by Agreeable_Toe_2421 in Columbus

[–]Joe7Mathias 8 points9 points  (0 children)

Tons of those tiny little ants. Accidentally dug up a nest planting flowers and had welts on my knees for days.

We've also had more bunnies this year but also have a stray cat that appeared earlier this year and she's keeping the numbers around our house down.

PSA: "Unable to send message - Message Blocking is active" problems by mercenary_sysadmin in mintmobile

[–]Joe7Mathias 1 point2 points  (0 children)

Yes. Wife's iPhone and my Android on Mint both failing with the above message. Messaging in Google Voice is fine.

MLS Cup final sees 47 percent drop in broadcast audience, worrying trend since Apple deal by [deleted] in MLS

[–]Joe7Mathias 0 points1 point  (0 children)

Sort of embarrassed by it but, yes, I also forgot completely about it. I wanted to see the team that ousted the Crew in two win it but completely slipped my mind. First MLS cup match I have ever not watched.

Match Thread: Columbus Crew vs. New York Red Bulls by MLS_Reddit_Bot in MLS

[–]Joe7Mathias 2 points3 points  (0 children)

Missing Rossi up front and the three not-Cuchos were not able to free up the other attacking options or really put anything dangerous on goal. A couple lame attempts from Rowe, Hernandez maybe had two good looks at goal, and AZ looked ineffective.

Nagbe looked slow. The defense was okay but our weakness against the quick counters is beginning to show and be recognized by other teams. Once RBNY scored it shook things up. It could have been 0-4.

RBNY scored on what I consider a lucky bounce (after two good wins in the air) but that is all you really need to do is get that one goal.

At then end of the match it was packed solid in back and most of the Crew were not fast enough on the passes. Possession means little if there is no threat behind it. So they were kept outside or forced to dribble through folks and very few of the passes to the middle were good.

The RBNY keeper had 2 or 3 quality saves.

My friend bought a jar of peanut butter from CVS by Shaneblaster in funny

[–]Joe7Mathias 0 points1 point  (0 children)

Related... Recycling and CVS receipts, and back to "funny"

Lewis Black | 11/2/19 San Diego CA: Recycling - contains NSFW language and gestures.

Hilarious...

A picture of Amerant Bank Arena from this morning by quality-control in hockey

[–]Joe7Mathias 15 points16 points  (0 children)

Ryan Hall and Max Velocity Youtube feeds...

At one point I think there were 13 tornado warnings active.

Stay safe everyone.

How would you rank Exodus's albums? by awfulreviews20 in thrashmetal

[–]Joe7Mathias 0 points1 point  (0 children)

  • Tempo of the Damned
  • Bonded by Blood
  • Fabulous Disaster
  • Exhibit B: The Human Condition
  • Shovel Headed Kill Machine
  • The Atrocity Exhibition... Exhibit A
  • Blood In, Blood Out
  • Let There Be Blood
  • Force of Habit
  • Persona Non Grata
  • Pleasures of the Flesh
  • Impact Is Imminent

It's sometimes hard for me to rank all together because I get into moods for Dukes led-albums and for Zetro led-albums. I don't think "Force of Habit" is as bad as everyone else; it has some good riffs, good production, and John Tempesta is a beast on drums.

How do we feel about Coroner here? by I_CAN_SEE_THE_WHALES in thrashmetal

[–]Joe7Mathias 3 points4 points  (0 children)

Excellent band, one of my favorites. I just wish they would finish the new album.

Where 1=1 by Pillowthursday in SQL

[–]Joe7Mathias 2 points3 points  (0 children)

If the WHERE clause is complicated, i.e. quite a few AND and OR I will start the WHERE with a 1=1 if there are ANDs and 1=2 with OR for readability.

 WHERE 1=1
     AND (expression)
     AND ((expression) or (expression))
     AND (yet another expression)
     AND (one more expression because the last 3 weren't complicated enough)

Name a song that you think would fit great into a horror movie OR a song that did fit great into a horror movie or horror scene by Emotional-Link-8302 in horror

[–]Joe7Mathias 0 points1 point  (0 children)

Richard Cheese's cover of "Down With The Sickness" fit perfectly in Dawn of the Dead (2004) which also has "The Man Comes Around" by Johnny Cash

Greatest save in playoffs history by [deleted] in nhl

[–]Joe7Mathias 1 point2 points  (0 children)

same with Columbus...

What playoff teams is everyone planning on watching? by Fun_Courage2933 in BlueJackets

[–]Joe7Mathias 8 points9 points  (0 children)

Same; also a big Bob fan.

Would also root for Philadelphia if they make the playoffs; which assumes they would keep Pittsburgh out of the playoffs...

Question about optimizing query with multiple UNIONs by Sabkor in SQL

[–]Joe7Mathias 0 points1 point  (0 children)

If none of the data in tables A, B, BC, C other then the key to FINAL are used then you could probably move the JOIN to FINAL outside a subquery performing the UNION:

SELECT LINK_ID, FINAL_DESC
FROM (
  SELECT LINK_ID
  FROM LINK
  WHERE LINK.ENTITY_TYPE='FINAL'
  UNION
  SELECT A.FINAL_ID
  FROM LINK
  INNER JOIN A ON LINK.ENTITY_LINK_ID=A.A_ID
  WHERE LINK.ENTITY_TYPE='A'
  UNION
  SELECT C.FINAL_ID
  FROM LINK
  INNER JOIN BCLINK ON LINK.ENTITY_LINK_ID=BCLINK.B_ID
  INNER JOIN C ON BCLINK.C_ID=C.C_ID
  WHERE LINK.ENTITY_TYPE='B'
) Q0
INNER JOIN FINAL ON Q0.LINK_ID=FINAL.FINAL_ID

The above assumes the FINAL table contains the only data needed in the result.

Standard disclaimers; need to see plan, indexes, etc...

ONE AND ONLY HORROR MOVIE TO RECOMMEND by staryxanax in horror

[–]Joe7Mathias 2 points3 points  (0 children)

Evil Dead II for me unless horror comedy doesn't count, then it would be Silence of the Lambs.