SQL Server Performance Essentials – Full Course

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!

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

Awesome Rajan ji it is a great one very easy explanation

You are watching the video 😭

Wonderful.. thank you so much 🙏

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

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

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

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

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

Congratulations, very comprehensive course.

Presentation was great.Can i get that ppt ?

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

Kindly create a full course on SQL Server - DBA

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

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

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

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

Very useful, Thank you !!!

Great

Can you please build a program for Postgres Performance essentials

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.

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

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.

Selent!!!!!!

Great course, help me a lot👍

Writing...

Top class quality video

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

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

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

Great course, exactly what I needed!

We have only one like button 😒 Period

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

Great Course. Thank you so much.

I have idea to make mobile application

Would you like to invest and become a billionaire

A+++++

The back bone in either backend and front-end.

That Indian speaking make me smile)))

u r channel deserves 500 million subs

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

I coincidentally just started my database course yesterday

This was what i was looking for!

Your mother