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
bad plan

SQL SERVER – Parameter Sniffing and Bad Plan

August 5, 2021
Pinal Dave
SQL Performance
Parameter Sniffing, Query Hint, SQL Scripts, SQL Server

Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!

Read More
Parallelism in Express

SQL SERVER – Parallelism in Express Edition

August 4, 2021
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server

Recently a client reached out to me with a very interesting question, why is he not able to see the parallelism in Express Edition. Let us discuss today. 

Read More
Clean Pages

SQL SERVER – Dirty Pages vs Clean Pages in Memory

August 3, 2021
Pinal Dave
SQL Performance
SQL Memory, SQL Scripts, SQL Server

I was asked what is the difference between Dirty Pages and Clean Pages in SQL Server Buffer Memory and which one is better? Let us quickly discuss.

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

SQL SERVER – Finding Queries Using Particular Index

July 15, 2021
Pinal Dave
SQL Performance
SQL Cache, SQL DMV, SQL Index, SQL Scripts, SQL Server

One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.

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
Performance Observation

SQL SERVER – SUM(1) vs COUNT(*) – Performance Observation

June 25, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server

One question that kept on coming up was SUM(1) vs COUNT(*) – Performance Observation. Well, let us see that today.

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

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

Go to mobile version