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

Remove Key Lookup – SQL in Sixty Seconds #194

February 21, 2022
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Performance, SSMS

Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.

Read More

SQL SERVER – Is Query from Cache? Execution Plan Property

December 2, 2021
Pinal Dave
SQL Server
Execution Plan, SQL Cache, SQL Memory, SQL Scripts, SQL Server

Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?

Read More
Time of Stored Procedure

SQL SERVER – Execution Time of Stored Procedures

August 11, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Statistics, SQL Stored Procedure, SSMS

How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures

Read More
query cost

Tuning Query Cost 100% – SQL in Sixty Seconds #181

July 27, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server

After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.

Read More
query cost

SQL SERVER – Query Cost 100%

July 23, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server

How to tune a T-SQL with Query Cost 100%? 

This is indeed an interesting question and I have received during Comprehensive Database Performance Health Check.

Read More
Count Sum

One Scan for 3 Count Sum – SQL in Sixty Seconds #178

July 2, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Function, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.

Read More

SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)

June 30, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Function, SQL Index, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).

Read More
1 2 3 4 … 17 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version