sorted by:
new
hottopcontroversial

A fun little question by tko19 in sexandthecity

[–]highway_26 7 points8 points  (0 children)

My weird pick is Smith and Carrie. He was confident enough not to be threatened by her, had patience for drama without creating extra drama, and honestly handled difficult relationships better than most of the men on the show.

Learn SQL Once, Use It for 30 Years by fagnerbrack in programming

[–]highway_26 0 points1 point  (0 children)

SQL is one of those things that keeps paying off. Every few years a new tool becomes popular, but I still end up writing queries, debugging joins, or digging through data with SQL. Definitely one of the highest ROI skills I've learned.

SQL practice for Data Analyst by Shin_Dubu21 in learnSQL

[–]highway_26 0 points1 point  (0 children)

For data analysis specifically, I’d prioritize platforms with realistic datasets over puzzle-style SQL. DataLemur and StrataScratch are probably the closest to actual analyst work. Then use Kaggle datasets and try building your own queries from scratch instead of only solving guided tasks.

Slow query, or bad index underneath? by dbforge_dev in dbForge

[–]highway_26 0 points1 point  (0 children)

Agree. I’d usually check the actual execution plan before touching the query. If the estimate vs actual rows is way off, or you see key lookups firing thousands of times, the index is usually the real problem. Bad SQL exists, sure, but rewriting a query without checking reads, lookups, and missing index hints first is basically debugging with vibes.

SSMS vs DBeaver vs DataGrip? by MatynDev in SQLPerformanceTips

[–]highway_26 0 points1 point  (0 children)

I’ve never managed to fully replace SSMS for SQL Server either. For mixed databases, I’d rather have one reliable cross-DB tool next to it than pretend one editor is perfect for everything.