5 SQL in Sixty Seconds Video on SSMS Efficiency

SQL Server is my favorite database platform and I enjoy working with T-SQL as well. The most interesting part is that when we are working with SQL Server, we get to work with SQL Server Management Studio aka ‘SSMS’. I make my living by Comprehensive Database Performance Health Check and one of the constant struggles which I see of my client is to use SSMS Efficiency.

5 SQL in Sixty Seconds Video on SSMS Efficiency 5video-800x438

In today’s blog post we are going to see 5 SQL in Sixty Seconds videos which are focusing on SSMS efficiency only.

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 queries 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.

Well, these are just a list of my favorite blog post which contains blog post related to SSMS efficiency. If you want me to create a video on any of the SSMS efficiency tips, just leave a comment and I will be happy to create video on that topic.

Reference: Pinal Dave (https://blog.sqlauthority.com

, ,
Previous Post
SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142
Next Post
Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143

Related Posts

Leave a Reply

Menu