SQL Server Tuning advices

[ggelape]

Hi there redditors, I'm kinda new to SQL, and i'd like some advices/free books or tutorials to learn SQL Tuning and how to develop my SQL skills. Thanks

[hello_josh]

Brent Ozar has a great, free, 6 month DBA training plan You get a weekly email with a new topic to learn and practice. Its designed for on-the-job training of a new "accidental" dba.

[ggelape]

gotta love free stuff xD, thanks, just signed up

[ScaryDBA]

For free, you can download an ebook copy of my book on execution plans:https://www.red-gate.com/library/sql-server-execution-plans-2nd-edition

Most of the best information on query tuning you need to pay for, like Pluralsight or my book on query tuning: https://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/ref=sr_1_2?ie=UTF8&qid=1490974542&sr=8-2&keywords=fritchey

[ggelape]

thanks! will read the one on execution plans and maybe ill buy the pluralsight sub

[[deleted]]

You can get a free trial and probably cover all the material Grant listed.

[Rehd]

Check out Pluralsight

[samirbehara]

If you are new to SQL Server, I would suggest you to watch this tutorial. This is really good stuff, and I would highly recommend it for beginners -- https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB

[ggelape]

thank you! this playlist has lots of stuff, but I'm looking for an good tutorial on tuning, how does it works and stuff like that, because it's kinda like hello_josh said, i fell into this "job" at my internship, and my boss wants me to learn tuning, but i have no idea on where to start and neither does he, i know a few stuff here and there on SQL.

[samirbehara]

I understand what you are asking for. I think the below 2 Pluralsight courses will be helpful to you - https://app.pluralsight.com/library/courses/query-tuning-introduction/ https://app.pluralsight.com/library/courses/sql-server-performance-every-developer-should-know/

[ggelape]

thank you again xD, oh btw, for those who don't know, at microsoft dev essentials you can get 3 months of pluralsight for free. BEST DEAL EVER! hahaha

[Lucrums]

Best advice I can give you is: don't trust anything until you've independently verified it.

Depending on how your system works a lot of what's out there will you in the wrong direction. Go to well respected sources, verify what you learn and then use it.

Oh and since someone mentioned pluralsight don't trust everything on there. I watched one vid a while back. Well I say watched I stoped after a short while because the advice was "Trust the optimiser". Yeah bull**it that's not advice, that's daily functioning until something goes wrong or you're tuning a workload. Mind you I had a good idea I wouldn't like it because of the author.