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.
Question: What is EDGE in SQL Server Execution Plan?
Answer: It is the arrow or the line which goes from one operator to another operator.
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.
Lots of people asked me to share the SSMS efficiency tip so I have shared the same in this blog post. Today’s topic is the pinned tab in SSMS for efficiency.
I often struggle to remember the changes done to the stored procedure and in this situation, the Split Screen of SSMS really comes very helping.