March 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
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
JOIN Elimination

SQL SERVER – JOIN Elimination for Not Selected Column

November 25, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Statistics, SSMS

The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.

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
kbsc

SQL SERVER – Configurable KeyBoard Query Shortcuts for SSMS

November 19, 2020
Pinal Dave
SQL
SQL Server Management Studio, SQL Shortcut, SSMS

Today we will learn something very simple but fun stuff for SQL Server Management Studio (SSMS) which is about Configurable KeyBoard Query Shortcuts.

Read More
wordwrap

SQL SERVER Management Studio – Word Wrap

November 13, 2020
Pinal Dave
SQL Tips and Tricks
SQL Server Configuration, SQL Server Management Studio, SSMS

One of the requests I usually do to my client when they are using SQL Server Management Studio is around Word Wrap. Let us learn about it today.

Read More
logical read

SQL SERVER – What is Logical Read?

November 12, 2020
Pinal Dave
SQL Performance
Logical Read, SQL Server, SQL Server Management Studio, SQL Statistics, SSMS

Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.

Read More
Efficient Query

Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140

October 30, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Operator, SQL Performance, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.

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

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

Go to mobile version