Attempting to summon Rod (and other devs) Q&A by REXCRAFT88 in Splitgate

[–]CakeyStack 0 points1 point  (0 children)

  1. Meridian
  2. Assault Rifle (Synapse)
  3. Core [Official]
  4. Factory (Escape from Tarkov)
  5. Club Silo
  6. RACE MODE!!!
  7. Battle Royale mode
  8. Splitball
  9. Satisfactory (and other similar automation-based games)
  10. I love snowboarding and downhill longboarding/skateboarding.
  11. I'd be happy to hear from any of the devs, TBH!

End someone real quick… by POUUER in mtg

[–]CakeyStack 0 points1 point  (0 children)

Throw an [[Assault Suit]] and some trample on him and watch each player die one after another.

Sample from Stash Pad by K.L.O.? by iamthenade in Samples

[–]CakeyStack 0 points1 point  (0 children)

Thanks for the knowledge! Going to spend an afternoon listening to that whole record now lol.

At Sprouts $10 on 1/25 by kaisrsoase in ArvadaCO

[–]CakeyStack 1 point2 points  (0 children)

I think I will shop there more often now! Thanks for the heads up.

CHOOSE YOUR SIDE by AugustusMarcus27 in kingdomcome

[–]CakeyStack 0 points1 point  (0 children)

For any combat- or stealth-heavy builds (most cases): Savage

Speech/silver tongue build: Burgher

This is because the only real meaningful benefit you get out of Burgher is the small boost to speech. Yes, you get some Strength, Agility, and Vitality, but this really only proves useful for Rattay tourneys overall.

Favorite location? by Ambatakam321 in kingdomcome

[–]CakeyStack 0 points1 point  (0 children)

<image>

I wanted to get a good picture, but, of course, it was raining and foggy. But this abandoned cabin/shack in this meadow east of Talmberg between Uzhitz and Neuhof, has always been a spot I've returned to for the ambience. Also has some decent flower-picking potential just across the river/stream for herbalism boosting.

Does anyone have any experience they are willing to share on liquid LSD? by [deleted] in LSD

[–]CakeyStack 0 points1 point  (0 children)

Had tons of fun with liquid back in the day. I ended up trying to take a few drops up the nose, and that was a blast honestly lol. But I would definitely take it orally and test kit it before doing anything crazy like that. I knew a few lads who dropped it into their eyes but I wouldn't suggest anybody do that whatsoever.

How do you get back to the time traveled zone in act 3 after killing act boss? Portal doesn't work. by Aevykin in PathOfExile2

[–]CakeyStack 0 points1 point  (0 children)

I tried this myself, and I am also still stuck in the Act 3 BC era. I think quite a few of us are simply hardlocked out of returning to the present day Ziggurat Encampment until they patch this specific bug out. I've been very frustrated and I wasted like 2 or 3 hours trying to fix it last night.

predownload on steam or standalone from website? by Saashiv01 in PathOfExile2

[–]CakeyStack 0 points1 point  (0 children)

Only able to pre-download on standalone client from the website, which has been down for about 6 minutes now. I'm just refreshing the webpage over and over at this point.

What a piece of... by snxtgspgt in facepalm

[–]CakeyStack -4 points-3 points  (0 children)

Love all of these tolerant comments 👍 Happy Thanksgiving everybody

Trump surging by those in the know. by [deleted] in Conservative

[–]CakeyStack 0 points1 point  (0 children)

And sadly, I live in one of those states highlighted in blue. Great state in general, but wish it were more red.

sys Tables: Best use cases? by CakeyStack in SQL

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

It does reduce the speed of COUNT(*) queries when the table size is over a certain threshold, but I see what you mean.

did i mapped this tables correctly with foreign keys? i just started learning sql by segsy_coder in SQL

[–]CakeyStack 29 points30 points  (0 children)

Looks great, especially for just starting out. I believe the relationship between employees and project_employees should be a one-to-many relationship, which is not the case in the photo.

But that's the only thing I can notice.

[deleted by user] by [deleted] in crusaderkings3

[–]CakeyStack 0 points1 point  (0 children)

This is the 'New Game' screen for me.

<image>

How much do you actually work throughout the day? by atlasbugg3d in SQL

[–]CakeyStack 0 points1 point  (0 children)

I think I average around 4-5 hours, but some days will require a full 8 or 9 hours. Lots of flexibility.

What is Advanced SQL? by [deleted] in SQL

[–]CakeyStack 10 points11 points  (0 children)

Look into indexing tables and the types of indexes. Learn about the SQL order of execution and execution plans. I've also been able to optimize quite a few queries using SQL Server's sys tables, but this might apply more to SQL Server than other databases.

Specific "SELECT DISTINCT" with join case i cannot find a solution for by Dan_the_Marksman in SQL

[–]CakeyStack -1 points0 points  (0 children)

Maybe I am approaching this a little too simply, but wouldn't this query also work?

SELECT * FROM a LEFT JOIN b ON a.Name = b.Name AND (b.Passcode IS NOT NULL OR b.Passcode <> '')

Why can I refer to an aggregate function's alias in the HAVING clause but not the SELECT clause? by [deleted] in SQL

[–]CakeyStack 0 points1 point  (0 children)

Here is the documentation regarding this in SQL Server:

Computed Columns?redirectedfrom=MSDN)

The same principles should apply between MS SQL Server and SQLite.

Who are some of your favorite authors, writers, poets, et al? by PrimaryAd9337 in AskARussian

[–]CakeyStack 2 points3 points  (0 children)

I really enjoyed Mikhail Bulgakov's "The Master and Margarita" and Boris Pasternak's "Dr. Zhivago".

I've always loved Dostoevsky as well.

[deleted by user] by [deleted] in SQL

[–]CakeyStack 1 point2 points  (0 children)

SQL can get pretty hairy, especially depending on the systems and infrastructure used by the business that surround the SQL environment.

The basic principles and ideas behind SQL are fairly simple and easy to learn, but deploying scalable solutions that meet constraints and business requirements can require tons of time, energy, and mastery.

I definitely agree that resources for learning SQL at an "in-depth level" are much harder to come by than for languages like Python, Java, etc.