May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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
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
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
query shortcuts

SQL SERVER – Query Shortcuts

November 26, 2020
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SQL Shortcut, SSMS

One of my clients who hired me for the Database Performance Health Check got very impressed that I was able to use efficiently query shortcuts.

Read More
SSMS Efficiency

5 SQL in Sixty Seconds Video on SSMS Efficiency

November 20, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Management Studio, 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. 

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

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

Go to mobile version