Hey! this is Rajan Arora. Thank you so much Beau for posting my tutorial. I hope this will help all the viewers to tune their SQL Statements in MS SQL Server. I hope we have more collaboration like this in the future!

@abdulwahab-rw1yq

2 жыл бұрын

Thanks Rajan.. this is really one of the best vidoes i have watched on peformance tuning

@ICodeMechanic

2 жыл бұрын

@@abdulwahab-rw1yq Thanks for the feedback

@ahmad-murery

2 жыл бұрын

That was not just a good refresher to me but I also learned some new things, it's 4 hours long but definitely worth it, Well done Rajan, and thanks Free Code Camp for sharing,

@DivakarRaj

2 жыл бұрын

Could you please provide link where the DM queries can be accessed from

@dev.maazqureshi

2 жыл бұрын

Thanks, Rajan This course is just excellent.. love it!

Exactly what I need. Thank you, Mr. Rajan and FCC team.

Very elegant presentation with crisp and clear explanations. Thank you for the amazing effort. This helped me immensely and so would it have been for several others there I bet!

As someone that has been writing code for 40 years I totally agree with your initial premise. If you are writing the SQL you need to understand how it operates and the costs/tradeoffs you may be making. Your video content was very well organized and presented.

@ICodeMechanic

2 жыл бұрын

Thank you for the feedback

@parthasarathiramachandran8189

Жыл бұрын

Timstamps for various topics covered.. 10:08 Spooling: duplicate aggregation: 18:21 Hashmatch: unsorted data 23:54 KeyLookup: missing data kzread.info/dash/bejne/pmaGko-xk67dZJc.html

This is wonderful course. I have been waiting to learn these techniques. Thank you so much for making it.

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

I am a self-taught developer 😍 who after years of Js and React, and on my KZread channel 🧑🏻‍💻 I create projects with React and tailwind or Html and Css… right now I’m learning Python and as you well know, SQL is part of his world. This video comes at the right time 😎

Outstanding video and resource, thank you so much for making this!

You guys are the best!

This tutorial is absolutely great and helpful !!!!!. Hope to see another vid about MySQL and Postgre !!

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

@alexgeld7173

Жыл бұрын

@@ICodeMechanic So, can I do it with Azure DataStudio on a Mac?

I'm glad have found this jewel. Thank you very much.

This was what i was looking for!

Great course, exactly what I needed!

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

Congratulations, very comprehensive course.

I coincidentally just started my database course yesterday

Thank you so much for this course, exactly what I needed.🤩

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

u r channel deserves 500 million subs

Wow great.this is what I was expecting.thank you so much

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

Thanks Rajan - great course!

Wonderful.. thank you so much 🙏

Thank you so much for very imp this and if you have any more like this then please upload it.

great tutorial. Thank you very much!

Awesome Rajan ji it is a great one very easy explanation

Wonderful.

Very useful, Thank you !!!

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

Great Course. Thank you so much.

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

Timstamps for various topics covered.. 10:08 Spooling: duplicate aggregation: 18:21 Hashmatch: unsorted data 23:54 KeyLookup: missing data kzread.info/dash/bejne/pmaGko-xk67dZJc.html

Kindly create a full course on SQL Server - DBA

Great tutorial we need more SQL Server tutorials, please in the future make a SQL Server DBA, SSIS, SSRS tuts thank you

@surajkhot7530

2 жыл бұрын

I also want

@joshi1q2w3e

2 жыл бұрын

Especially SSIS because jobs everywhere still ask for it but I can’t find resources to learn it.

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback and your suggested topics are noted

@lillyoko7838

2 жыл бұрын

פבחבןבפןב

@lillyoko7838

2 жыл бұрын

יי פיב

Hi..very useful video..Is there any training available for SQL performance tuning in dba or architect level?

I love you guys ❤️❤️❤️

Learning about Databases is so important because almost everything in this world contains a database

@ICodeMechanic

2 жыл бұрын

True

At 1:59:11, you have shown an index as lastname,firstname,degreeid. Will the 3rd sql query be able to utilize this index for degreeid?

Top class quality video

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

Great job from you people.

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

@rajanarora5107

2 жыл бұрын

@@sidch15 🙏

KYA BAAT HAI

Thank you for sharing this good course.Can you share the ppt.

I'm running SQL server 2017 and I don't get any results back when I run the query for 2.6. Also, if I compare the estimated execution plans for both queries I don't see an entry for "Top" with the query using "WHERE NOT EXISTS". For the first issue, I would guess that I could delete all records from the CourseEnrollments table where the CourseOfferingId is 56637 or 58317. With the second issue, I can only guess that my version of SQL is coming up with a different execution plan, and I have no control over that? UPDATE: Looking at the video again, I saw that there is an Index Seek on the CourseEnrollments table, so it looks like the database backup is missing that. I added the following index and my execution plan now matches what is shown in the video: USE [Students] GO CREATE NONCLUSTERED INDEX IX_CourseEnrollments_CourseOfferingID ON [dbo].[CourseEnrollments] ([CourseOfferingId]) GO

Awesome

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

Selent!!!!!!

Great

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

I executed the same query as the section 2.6 at (0:52:30) and got a different result that was an empty table. I wonder why ce.CourseOfferingId is specified as NULL. It supposes to have a not-null constraints. Would you please teach me?

@ebenbrittz535

6 ай бұрын

Yes, I also got this, and the SQL Execution plan is completely different to what is shown in the video.

❤️

The back bone in either backend and front-end.

Which version of sql server we will learn in this vide?

Request you to please make a Video on SOC or SIEM 🙏 please it will help lot of people like me who can't afford Expensive courses #freeeducationforall

Great course, help me a lot👍

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

Presentation was great.Can i get that ppt ?

is there any book from where we can study all these?

Hello @codeMechanic .. I am using M1 MacBook Air and was wondering whether I can do this course? I currently installed Azure Data Studio on Docker but not able to do the students.bak exercise thus won't be able to run the queries.. where can I find the data so I do an import?

Where are the links ?

Hi sir, the tools which u are used in this video we can also use in oracle sql developer or not???

@ICodeMechanic

2 жыл бұрын

Sorry, but this is only for Microsoft SQL Server. it will not be used for Oracle Database

Can you please build a program for Postgres Performance essentials

@ICodeMechanic

2 жыл бұрын

Try my best to look into this.

@adwaitchavan6638

2 жыл бұрын

@@ICodeMechanic Thank you

Please post pl/sql course it will help many people

@freecodecamp

2 жыл бұрын

Here are some courses that may help you: SQL Course: kzread.info/dash/bejne/eoyKldyega7Xd7w.html MySQL Course: kzread.info/dash/bejne/d4Zs0a2RZdDfdZM.html University Database Systems Course: kzread.info/dash/bejne/ZpeLzbibc5XIfqg.html

@ICodeMechanic

2 жыл бұрын

Noted

SSIS please!

@ICodeMechanic

2 жыл бұрын

Noted

What's a great video, are concepts and strategies in this course applicable for PostgresDB ?? or for all SQL languages no matter whether it's SQL server or PostgressDB ????

@phenomenon7030

Жыл бұрын

Did you find an answer for your question ?

Does this work for MySQL database?

@Louisianish

2 жыл бұрын

Probably to an extent, but they are different database management systems. I’m sure a lot of this is applicable to other RDBMS like MySQL and PostgreSQL, though.

@ICodeMechanic

2 жыл бұрын

No Shawon, it only works with Microsoft SQL Server

@michaelcheung6290

Жыл бұрын

​@@ICodeMechanicoh why? Because these are implemented very differently in other RDBMS?

Olaaa

set speed to 1.5x⭐or you will sleep, although very profoundly and well

@ICodeMechanic

2 жыл бұрын

🙂 Thanks for the feedback

2nd

Can you make solid works video plzzzz.

@Louisianish

2 жыл бұрын

I’m sure they’re working on it. Solid is a fairly new framework, right?

Hi freeCodeCamp! I'd like to ask you if you can make tutorial for C++ desktop development. Thanks 😀

@ahmadfaisal6356

2 жыл бұрын

They already make it, go check it

hay bruh

@MyJourney2succeed

2 жыл бұрын

Hay bruh

@simplyritik

2 жыл бұрын

hay bruh

@MyJourney2succeed

2 жыл бұрын

Hay bruh

A+++++

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

if youtube allows users to change the accent of the videos based on the scripts, that would be great

I have a query, it works very speed but suddenly it's taking more time, I can optimize but I want to know the root cause why it works before why it's not now ?, can you please tell me what can I do to know the root cause

Writing...

That Indian speaking make me smile)))

@ash3rr

2 жыл бұрын

The Indian makes my ears cry.

Can't send 100 likes to your course 😂

We have only one like button 😒 Period

@ICodeMechanic

2 жыл бұрын

Thanks for the feedback

I don't like SQL Server for example, I need to get a select result and generate script to insert based in values for the query to put in other table or database its impossible without payable tools. In MySQL its easier.

I have idea to make mobile application Would you like to invest and become a billionaire

Your mother

You are watching the video 😭

not working- download database backup files - students.bak is not visible to download. please check