Here is the SQL in the Sixty Seconds video.
Here are all the scripts used in this video.
Here are a few of my recent videos which you may find interesting.
Arrow in Execution Plan – SQL in Sixty Seconds #136
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.
SSMS Efficiency – Replace STAR – SQL in Sixty Seconds #130
You might have heard that SELECT * is bad for query performance. Let us learn in today’s video how we can replace STAR (*) by column name.
Cycle Clipboard Ring – SQL in Sixty Seconds #129
Copy (CTRL + C) and Paste (CTRL + V) are the friends of the DBAs and Developers. In SQL Server it is totally possible to use the Cycle Clipboard Ring.
Split Screen for SSMS Efficiency – SQL in Sixty Seconds #120
I often struggle to remember the changes done to the stored procedure and in this situation, the Split Screen of SSMS really comes in very handily.
Full-Screen Execution Plan – SQL in Sixty Seconds #117
There are two primary tools – 1) Execution Plan and 2) Statistics IO. In this blog post, we will see how we can get the full-screen execution plan.
Reference: Pinal Dave (https://blog.sqlauthority.com)