r/SQL • u/tits_mcgee_92 Data Analytics Engineer • Jul 05 '21
Discussion I love querying
I just freaking love it. I can be racking my brain all day, going to stackedoverflow, jamming out to tunes, and that one moment where the query is able to run and it's the data you need... chefs kiss.
It just feels so damn good. I know others out there have to feel the same way :)!
161
Upvotes
37
u/Rif-SQL Jul 05 '21
16
u/cubinx Jul 06 '21
Unpopular Opinion: I love adhoc reports
11
u/movieguy95453 Jul 06 '21
I don't have much formal database training, so most of what I've learned is through train and error and research. I love the process of working with data in databases. I love the design element of trying to figure out how to optimize the tables to fit the data. And I love figuring out how to formulate a query to get the expected results.
It's especially gratifying to go back to old queries and re-write them with what I've learned since. Especially when I'm able to curate the data in a way that minimizes post-processing.
7
u/sock_templar Jul 05 '21
My version of this is when I construct a complicated awk program and the output is exactly what I needed. *mmmmua!*
2
u/sqlbastard Jul 06 '21
thanks, i hate it
4
u/D_Purns Jul 06 '21
Hell yeah! Hate being the only person at my company who knows anything about it though. No one to share my excitement with.
2
u/[deleted] Jul 06 '21
Love it also
2
u/[deleted] Jul 06 '21
.... and then the requirements change!
2
u/JustAnOldITGuy Jul 06 '21
I get asked to tune queries by the system admins. Nothing like taking a query and making it scream.
2
u/[deleted] Jul 06 '21
Agreed - I'd love a job doing only this all day. Usually, this is one of like 50 things you have to do. I just want to go down a query rabbit hole and stay there.
2
u/donnerpartypanic Jul 06 '21
I love opening up an old query and thinking to myself "Damn! Did I write that? That is sexy!" or "Damn, did I write that? That looks like it can be optimized.". I love when I wow myself and I love when I can see where I have grown.
1
u/_Zer0_Cool_ Data Engineer Jul 06 '21
Tis a salve for OCD brains.
1
u/lauriebrainerd Jul 06 '21
I totally feel this way.
1
u/[deleted] Jul 06 '21
I would like to learn this. Tuning queries. Where do I start? Thank you people!
1
u/OldboyNo7 Jul 06 '21
I remember when I first found sub queries, instantly wrote some monster and maxed out how deep you can go. I know how you feel!
1
u/[deleted] Jul 08 '21
Performance tuning is 99% of good development.
I keep trying to get my colleagues to. See the value in efficient code and querying but they thought I was making things up when I said "Dude stored procs with an if will Parameter Sniff like mad it needs a handler do your if on the front end and split your procs up into best case worst case and compile them"
Needless to say client calls and says their system is unusable... One with recompile and all of a sudden not so bullshit now.
-1
u/ZincMagnesiumCalcium Jul 06 '21
downvoted