Feb 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
find a table

Find a Table in Execution Plan – SQL in Sixty Seconds #151

January 27, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS

While all other methods work fine, let us see how easily we can find this in an SSMS. Let us learn how to find a table in an execution plan.

Read More
find a table

SQL SERVER – Find a Table in Execution Plan

January 25, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Server, SQL Server Management Studio, SSMS

Of course yes, we can easily find a table in the execution plan with the Find Node feature of SSMS (SQL Server Management Studio).

Read More
Text Output

SQL SERVER Management Studio – Grid vs Text Output

January 15, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SQL String, SSMS

they asked me questions if I know how to fix it. Well, it is actually very simple and we need to learn about Grid vs Text Output.

Read More
goal optimizer

SQL SERVER – Disable Rowgoal Optimizer

December 28, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?

Read More
Rows Read

SQL SERVER – Number of Rows Read – Execution Plan

December 25, 2020
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Index, SSMS

Recently one of the clients sent me images from the execution plan and his question was about the Number of Rows Read in the SQL Server Execution plan.

Read More
line numbers

Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147

December 15, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS

This is when the line numbers in SSMS comes in extremely handy and let us learn in today’s blog post how we can do that. Let us learn today.

Read More
query shortcuts

Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143

November 27, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Management Studio, SSMS

I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.

Read More
Previous 1 2 3 4 5 6 … 25 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version