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

The real challenge is the definition of an efficient query. Everybody has their own definition of an efficient query. In today's SQL in Sixty Seconds video, I discuss the definition of the efficient query and also explain my real-world experience with my client.

0:00 Intro
0:28 Real World Scenario
0:47 Demo
1:08 Most Important Question
1:41 Execution Plan
2:12 Video On Set Statistics IO On
3:37 Video On Set Statistics Time On
4:53 Question for the Viewers
5:24 Summary

#SQLServer #PerformanceTuning #SQLAuthority

[Dawar]

Pinal Dave is truly remarkable for his deep expertise and practical insights in SQL Server.

[jinanchehab]

Pinal, you are an SQL Wizard! Thank you for the continuous SQL video learning series . Great work. You are my first reference when I have to troubleshoot my SQL Queries performance .

[gohe]

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

[GaneTcr]

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

[arpitbest]

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

[SwapanD]

Have got immense help from you Pinal for the last 15 years.. You are an institution. Take my sincere regards.

[MUHAMMADALI-nbtm]

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

[pradeepkumarkr]

It's evident that all three queries are good in the context of I/O, CPU, and plan percentage. Sometimes we won't get all the good measures in a single query and for that reason, we say it as performance 'tuning'.

[thearchibaldtuttle]

This is Gold! Thank you! It would show the most efficient query, even the query itself is written very inefficiently from a solution point of view!

[khaledbudajaja]

Well presented Pinal.
SQLAuthority.com has been a generous source of information and a rock solid point to fallback when we have a tuff SQL times.
Big fan

[axioworks]

Brilliant article! STATISTICS TIME AND IO are my new best friends :-)

[TravellerPande]

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

[boopathirajkarunaiappan]

I am really happy this SqL Authority blog is now on videos. Than reading the blogs, it's more clear Pinal. Thank you so much.

[SaifulIslam-cnii]

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

[rgulamhussein]

A real eye opener Pinal! Thank you! I always thought that I/O would automatically improve when the execution plan is optimized. I've relied on your articles a lot over the years. Thank you!

[ricklangdon]

Another great subject. Reminded that it's important to clarify what the client/stakeholder views as 'most efficient' when taking on such a task. Very well done.

[pault]

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

[ericrouach]

Thanks Pinal, very clearly explained.

[iliashterev]

I am your fan for many years. Thank you and god bless you. I wish I could give you one thousand likes.

[dennisfike]

Thanks Pinal, I've definitely picked up a lot from you over the last 10-12 years, but still not a sql expert as I spend a little more time in frontend or backend web code. Every time I watch one your videos or read a blog post, I always come away finding out how much I don't know. Good stuff as always.