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
good or bad

Index Scans – Good or Bad? – SQL in Sixty Seconds #174

June 14, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

Index Scans – Good or Bad? Lots of people ask about this question and I have built a blog post on the topic – SQL SERVER – Index Scans are Not Always Bad.

Read More
index scan

SQL SERVER – Index Scans are Not Always Bad

June 11, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Scripts, SQL Server

Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.

Read More
Optimize for Adhoc

Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173

June 10, 2021
Pinal Dave
SQL Video
Ad Hoc Query, Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Configuration

Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.

Read More
Avoid Join Hints

Avoid Join Hints – SQL in Sixty Seconds #172

June 8, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Joins, SQL Server

Question: If they can change the join hints to improve the performance of the query. Well, the reality is that I always Avoid Join Hints.

Read More
One Query

SQL SERVER – 3 Questions Answered on One Query Many Plans

June 4, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL Performance, SQL Server

Yesterday I published a video One Query Many Plans – SQL in Sixty Seconds #171 and I received lots of questions on the topic.

Read More

One Query Many Plans – SQL in Sixty Seconds #171

June 3, 2021
Pinal Dave
SQL Video
Execution Plan, SQL Cache, SQL in Sixty Seconds, SQL Performance, SQL Server

After the blog post, lots of people asked me it will be more helpful if I can create a video on the same topic of one query many plans.

Read More
Join Type

SQL SERVER – Change Join Type for Query

April 22, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!

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

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

Go to mobile version