Performance Challenge - Write Efficient Query - SQL in Sixty Seconds 140

All i can say is amazing.

Great

Great video. Do you have any URL or UDEMY course about SQL Tuning on SQL Server and SQL Server Instance-Server Tuning also? Please let me know.

Hello Pinal how can we get the info of deadlock situation happened in the past

Really helpful video for SQL query performance PoV. Thanks a ton SQL genious Pinal

Very best Sir

Thats why you are genius sir, and because of this many of us following you though have other bloggers

Could you please create such video for Azure Data warehouse(Dedicated SQL Pool) . There optimization concept varies from normal sql database

@Pinal, I am a bit confused, can you please clarify again here?
Are you telling that the performance check depends on the client's needs? either he is interested on IO or Time, developer need to check with him on it?.

Day by day I am learning a lot from you sir. Thank you so much for teaching all of us. God bless you.

Thanks, appreciate it. My first thought was #2 as that's normally the fastest (and the one I would use).

Thanks Pinal, very clearly explained.

Hello sir I have one sql stored procedure and it is almost taking 3 minutes to get 75K records. Can we do improvement this SP? Please provide your inputs.

Mr. Bond you are savior. Really useful info...could you please also know in terms of query efficiency what metric stand out the most IO read or Elapsed Time taken query to execute. Shouldn't execution plan give result based on IO read and Elapsed Time?

Never seen anyone explaining sql with so much of excitement! Thank you Pinal Dave!!

Nice video, Please make a video on how to write a query interms of Excecution plan, CPU Usage and Time. Is using subquery reduces the performance ?, Joins vs using subqueries. Is using IN clause makes query slower ? If yes any other alternatives ?

Thank you

Thank you for a very clear and informative video. Exactly what I needed.

I am quite new to SQL. If I want to know more about what is page reads and how Statistics work then any guide ?

Just got this video from suggestion, and my conclusion is u are superb sql man..

I had guessed the third query but had failed to realize that we were then using the results of the aggregate to interrogate the table a second time.

One key point to remember is if the query might be executed multiple times. Sometimes, the optimizer can cache the results. This is particularly important when the query may be processed for multiple requests. This might occur on a website for example. I always like to understand the usage that will happen, so I can test what happens if the query is executed with different filter criteria for multiple requests (or maybe the same...). I have found that some compatible queries might be slower for the first execution, but subsequent queries cause the original (slower query) to be faster. (A key reason to use procedures/functions and make them deterministic...[Will not execute multiple times if passed the same parms.)

Great tip

The web is full of answers to my SQL questions. Your website is my "go-to" default getting the right answer.

You are awesome

Window functions?

Last several yours we are reading your articles.. you are doing asume work .... keep it up please

Good morning
I would like to join if there any existing training batch . Have a wonderful day ahead. Thank you

Do you have systematic SQL playlists?

Awesome sir, ur like SQL encyclopaedia.. I just had a chance to watch ur presentation to craft … It’s really surprised me … Can you please do videos on performance tunings in procs & Indexes … Thanks a lot in advance 🙏🙏🙏

One small doubt:
When we run for the first time, is it cached by Oracle in redo log buffer??
& Whenever we re-run it query translation time is skipped will affect timing of 2nd & 3rd run
Thanks
🙏

Efficiency of Execution plan versus efficiency on time how is this different? Could you pls explain

It will be helpful if you can explain with reason difference in performance for each query.

Thank you sir, very well explained.
Sir can you please create a course for Performance tuning and optimization.

Good explanation thank you pinal Dave sir

Great explanation. Keep it up and wait for another more than 60 second video. 👍👍

How do you determine that the bottleneck is IO as opposed to something else?

Great..

Hi! I am just writing a comment just to see if you will really read it and answer it.

bossman, you're a genius. thank you for this video.

Can I have theses three queries

Continuation of previous comment : 1. What steps will you take If your procedure starts behaving slow 2. What things you would take care before writing a stored Procedure 3. What steps will you take If your SQL server starts running slow...
I am desparately looking for these 3 kind of videos from your Channel which I need to watch fromyour side only..

Hi Pinal, I am big fan of your SQL in sizty seconds short videos series..I am desparately looking for a video from your side about 2 scenarios which is mostly asked in Interviews :

Thanks pinal. It's very useful for me..

Brilliant!! Those three factors are has to be in considerations

Great video!!!

your blogs are very help full for the DBAs great effort

can you share same things with huge data, indexes, and caching

I believe Window Function, because I believe it only requires one table scan.