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