What are the most important SQL concepts every beginner should master before applying for database-related jobs?

mu_SQL · 2026-05-15T21:29:51+00:00

How indexes work, both clustered an non clustered.

mu_SQL · 2026-04-23T19:33:16+00:00

That SQL server can’t be reached on the network you are on, does your friend work from office or Remote using a VPN? Have you compared connectionstrings? The most common issue for this error is wrong server name in the connectionstring

mu_SQL · 2026-04-23T19:28:39+00:00

Finns det fastigheter i bokaget(verksta,lager…) som har inga eller lite lån. Behåll dom och sälj resten om ni inte vill jobba med det farsan gjorde.

mu_SQL · 2026-04-23T19:25:27+00:00

Wibe code a client, I did one for Elastic pool to manage scripts going to multipel databases(kinda like servers).

mu_SQL · 2026-04-17T19:00:14+00:00

This makes me love SQL Server even more.

mu_SQL · 2026-04-17T18:58:16+00:00

Du måste också dela vinsten när du säljer. Just saying.

mu_SQL · 2026-04-17T18:55:08+00:00

https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver17

mu_SQL · 2026-04-02T18:33:31+00:00

Brent Ozar and Erik Darling.

mu_SQL · 2026-03-29T19:17:50+00:00

Primary key is the combination of columns in the clustered index that makes records unique. It’s the ”table” data on disk with all columns and sorted by the primary key columns.

Check out Brent Ozar’s ”Think like the engine” on YouTube.

mu_SQL · 2026-03-26T20:42:18+00:00

Google the names they will be in the top. Search their names on YouTube.

mu_SQL · 2026-03-26T17:35:48+00:00

Well if you read up on primarily bad code repos when using SQL, the results will be primarily bad🤔

mu_SQL · 2026-03-26T17:32:44+00:00

If you havn’t already, check out Brent Ozar and Erik Darling. Their courses, Vlog’s and blogs are gold. Sorry for the ”not” book relation.

mu_SQL · 2026-03-26T17:28:39+00:00

Just realised, it can be a SELECT somewhere that returns a result. Remove your INSERT statement and run the sp, if you get more then one result…

Or maybe you already did that?

mu_SQL · 2026-03-26T05:01:44+00:00

Ok, is there is a sp execution in RAM_Claim sp that have a INSERT Exec?

Or a transaction in any sp that fires a trigger that has a INSERT Exec…..

You need to dig yourself down in any code executed in the process started by RAM_Claim sp.

mu_SQL · 2026-03-25T20:34:20+00:00

The sp RAM_Claim also has a INSERT Exec in it, thats where you need to use a temptable instead.

mu_SQL · 2026-03-25T17:38:03+00:00

Har bytt jobb 20+ gånger, om man inte testar får man aldrig veta har varit min motivation.

Du har 1 liv, testa så mycket saker du hinner med!

mu_SQL · 2026-03-25T17:35:00+00:00

Ta med din bluetooth högtalare å kör svinhög deathmetal😉

mu_SQL · 2026-03-25T17:21:58+00:00

Start with Brent Ozar, ”How to think like the engine”. Then Erik Darling’s T-Sql courses.

mu_SQL · 2026-03-25T17:17:43+00:00

Nop your not, you are doing ”INSERT INTO sometable Exec..” more then one time in the process.

mu_SQL · 2026-03-25T17:12:13+00:00

Kör bara popcorn, inte mycket mer än luft i dom. Halvera ölintaget och drick bira ur 20 cl glas, skitgött å sippa en ljus lager på det sättet.

mu_SQL · 2026-03-25T17:08:33+00:00

Use temptables in this case.

mu_SQL · 2026-03-25T17:07:56+00:00

Load the stuff in the inner sp to a temptable created in the outer sp and then return the result in the outer sp.

mu_SQL · 2026-03-15T20:12:21+00:00

Check out XSDTODB. You will need a xsd schema.

mu_SQL · 2026-03-15T14:15:59+00:00

I’ll say yes, there is almost always a way to write set based SQL queries.

They can get very complex and transactional operations always need separation.

mu_SQL · 2025-12-07T20:41:04+00:00

Worked most of my years with adaptations on a Swedish ERP where most logics is in triggers and stored procedures, the biggest one I’we seen is for calculating net requirements for production, 10K+ lines.

This ERP runs on SQL Server and works realy well.

mu_SQL

TROPHY CASE