Infinite Loop – SQL in Sixty Seconds #144

Earlier I wrote a blog post about SQL SERVER – Writing Infinite Loop. Lots of people wrote feedback about it and wanted me to explain in this video so I have built this new SQL in the Sixty Seconds Video where I discuss Infinite Loop.

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)