SQL Server Performance Essentials – Full Course

Selent!!!!!!

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.

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

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.

Can you please build a program for Postgres Performance essentials

Great

Very useful, Thank you !!!

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

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 ????

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

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

Kindly create a full course on SQL Server - DBA

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

Presentation was great.Can i get that ppt ?

Congratulations, very comprehensive course.

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

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

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

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

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

Wonderful.. thank you so much 🙏

You are watching the video 😭

Awesome Rajan ji it is a great one very easy explanation

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

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

Can't send 100 likes to your course 😂

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!

No man. no hindu. Close the video.

great tutorial. Thank you very much!

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

Thanks Rajan - great course!

Wonderful.

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?

Thank you so much Rajan for what i exactly looking for .
💯

Another codecamp course that doesn't indicate the version in the title or the description, which probably means it is an OLD version of SQL Server.

When he is comparing execution plans, why does he only look at estimated execution plans?? There can be a lot of useful information in the actual execution plan, which contains the actual values (actual number of rows read, etc.), which can differ a lot from the estimated values .... and such differences can be key in figuring out why a query runs slowly.

Thanks

If possible, run multiple queries at the same time. Results will be easier to compare when you have several execution plans in sight and can just hover a mouse over them for comparison.

is this course gonna help in to learn
msql server

Indian people english. Suddenly close the video ...

The Students.bak file is empty

bro became indian in minutes

indian accent makes me sleep...

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!