I have been building videos on SQL in the Sixty Seconds for a while and I have received lots of views and comments over them. Today we will be seeing the top 5 SQL in Sixty Seconds Videos.
Top 5 SQL in Sixty Seconds Videos
Here are the top 5 most loved SQL in Sixty Seconds Videos.
Video 1: Write Efficient Queries
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.
Video 2: Possible to Rollback TRUNCATE?
Is it possible to Rollback Truncate? If you know the answer, skip the video.
Video 3: Join or Inner Join
Have you ever wondered what is the difference between keyword Join and Inner Join? Are they same or different? If different, how are they different?
Video 4: Wait Stats for Performance
Let us learn three methods to do Wait Stats Analysis. Download Script and all-important details.
Video 5: Dirty Read with NOLOCK
Have you ever used hint NOLOCK to improve your query’s performance? Is NOLOCK good? What is actually dirty read?
Well, that’s it. I will be restarting to build a video on this series from the next week and I can’t wait for your feedback on this series. What would like to see next in this series of SQL in Sixty Seconds?
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
