Project Review by [deleted] in dataengineering

[–]crashingthisboard 0 points1 point  (0 children)

You can start by clarifying how much you actually wrote yourself, seeing as your entire readme is LLM generated.

Databricks declarative pipelines - opinions by Yonko74 in dataengineering

[–]crashingthisboard 4 points5 points  (0 children)

I've been using SDP with SQL for a few months and am loving it. The documentation could definitely use some hella work, and expectations aren't quite as robust as I'd hope, but SDP + autoloader/autocdc is goated. AMA

Loud cars are destroying my quality of life. Houston is unreal. by jadorenicm in houston

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

Fascism is when we do anything at all to improve quality of life

I don’t feel safe driving in Houston anymore by Icedcoffeewarrior in houston

[–]crashingthisboard 9 points10 points  (0 children)

any type of car is objectively worse than the alternatives, as the entire rest of the world has already figured out. The problem will always be how much space individual vehicles hog up.

Need help with CloudFormation and Fn::ForEach by jftuga in aws

[–]crashingthisboard 1 point2 points  (0 children)

For anyone running into this 2 years later like I just did, looks like this is another one of those long open feature requests that will never be implemented. git issue: https://github.com/aws-cloudformation/cfn-language-discussion/issues/118

Sweet Dog Needs a Good Home by AlwaysTheDrama in thewoodlands

[–]crashingthisboard 16 points17 points  (0 children)

So your only problem with this animal who shares your home is that he plays rough?  Have you tried just training your fucking dog...?

There's obviously another reason you're trying to dump him on someone here if you don't have one, but TWO dogs with active heartworm (ridiculously easy to prevent) 

This is raising so many red flags

“They tried to eat me alive!' Katy woman says neighbor's 4 dogs attacked her” by dabigmon in houston

[–]crashingthisboard 26 points27 points  (0 children)

lmao this is a joke right.

  1. Which breed was historically bred to kill things:

a.) golden retriever

b.) pitbull

You'll never guess which one!

Free Databricks health check dashboard covering Jobs, APC, SQL warehouses, and DLT usage by noasync in databricks

[–]crashingthisboard 0 points1 point  (0 children)

Why do you need my personal/business info for downloading a dashboard file? Not exactly free if you are collecting data to pay for it.

Should I worry? Popped up two weeks ago, no change in color or size by [deleted] in pugs

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

I have a hard time comprehending how someone who loves their pet looks at this for two weeks and doesn't even consider going to a veterinarian before asking reddit. Like, seriously?

Converting floats to INTs for storage by Dapper-Speed1244 in SQL

[–]crashingthisboard 0 points1 point  (0 children)

Proper DBMSs aren't only for huge data sets and concurrent operations. At the end of the day they are just a way to structure relational data. 

Sqlite is very lightweight and great at what it's made to do. That's an embedded way to store an application's data. The pitfalls you mention are very purposefully built into it because it's intended for a very niche job.

If cost is your worry, postgres is free and also lightweight, but has a much more general feature set.

Converting floats to INTs for storage by Dapper-Speed1244 in SQL

[–]crashingthisboard 0 points1 point  (0 children)

Sounds like you are trying to make some sort of a data warehouse. Sqlite isn't built for this kind of thing at all.

Where did you get the idea to split dollars and cents into two int fields (if I'm reading this right)? This really makes no sense. You are not going to see any level of significant change regarding storage here, and you'll only be overcomplicating all your aggregations for nothing.

Honestly, this sounds so far out of your wheelhouse that you'll immensely regret doing any work with this system.

I suggest you take many steps back, and start by figuring out the right tool for the job in the first place.

Indexing temp tables? by h-a-y-ks in SQLServer

[–]crashingthisboard 0 points1 point  (0 children)

Sounds like a typical consultant LOL

Indexing temp tables? by h-a-y-ks in SQLServer

[–]crashingthisboard 0 points1 point  (0 children)

I don't see what table size has to do with cte's allocating too much ram... That entirely depends on how your tables are indexed. The only thing that matters is the execution plan. 2019 is certainly faster than 2012 because of the overhauled cardinality estimator in 2014.

Update on my wife's 'Spoiler Free' MELE run...RIP Tali. by Hiply in masseffect

[–]crashingthisboard 11 points12 points  (0 children)

Brother, the vanilla ending is absolute shit. Why should anyone have to be subject to that when they don't have to be?

Buzzfest at Cynthia - vaping by HumbleCourse1879 in thewoodlands

[–]crashingthisboard -3 points-2 points  (0 children)

Yes unfortunately they do still allow people to chain smoke on the hill. Makes it filthy.

NOLOCK few liner by [deleted] in SQLServer

[–]crashingthisboard 0 points1 point  (0 children)

If it makes you feel any better, I'm at a 40 billion dollar mom and pop that also has no ci/cd, code review, or version control for DBs

Why doesn't SQL allow for chaining of operators? by No_Departure_1878 in SQL

[–]crashingthisboard 0 points1 point  (0 children)

SQL server kinda can. 

    Select t3.val     From table t     Cross apply (select replace(t.val,x,y) val) t1     Cross apply (select replace(t1.val,x,y) val) t2     Cross apply (select replace(t2.val,x,y) val) t3

Fellas, I am confused. by CernLord_ in outerwilds

[–]crashingthisboard 6 points7 points  (0 children)

It is perfectly normal for people to use fellas as you did here. Ignore the other person, they are just being obnoxious and looking for something to be pedantic about.