May 2026 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
  • Hire Me
  • Health Check
Nov10

How to Write INNER JOIN Which is Actually CROSS JOIN? – Interview Question of the Week #250

Pinal Dave
SQL Interview Questions and Answers
SQL Joins, SQL Scripts, SQL Server
3 Comments

Question: How to Write INNER JOIN Which is Actually CROSS JOIN?

Experienced this question another day while working with a client.

Read More
Nov9

Analyzing SQL Server Query Plans – Watch on Pluralsight

Pinal Dave
SQL Tips and Tricks
Execution Plan, Pluralsight, SQL Server
2 Comments

I have received some really great comments and feedback about this course. This entire week, I discussed various aspects of the query plans.

Read More
Nov8

Configure Azure SQL Database Performance Insight – Analyzing SQL Server Query Plans – Part 5

Pinal Dave
SQL Tips and Tricks
Execution Plan, Pluralsight, SQL Azure, SQL Server
No Comments

Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to configure Azure SQL Database Performance Insight.

Read More
Nov7

Compare Estimated and Actual Query Plans and Related Metadata – Analyzing SQL Server Query Plans – Part 4

Pinal Dave
SQL Tips and Tricks
Execution Plan, Pluralsight, SQL Server
No Comments

Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to Compare Estimated and Actual Query Plans.

Read More
Nov6

Create Efficient Query Plans Using Query Store – Analyzing SQL Server Query Plans – Part 3

Pinal Dave
SQL Tips and Tricks
Execution Plan, Pluralsight, Query Store, SQL Server
No Comments

I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss how to Create Efficient Query Plans Using Query Store.

Read More
Nov5

Identify Poorly Performing Query Plan Operators – Analyzing SQL Server Query Plans – Part 2

Pinal Dave
SQL Tips and Tricks
Execution Plan, Pluralsight, SQL Server
No Comments

I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Identify Poorly Performing Query Plan Operators.

Read More
Nov4

SQL SERVER 2019 is Released!

Pinal Dave
SQLAuthority News
SQL Download, SQL Server, SQL Server 2019
1 Comment

SQL SERVER 2019 is released today. You can get started immediately with it by downloading appropriate version for your system.

Read More
Previous 1 … 124 125 126 127 128 129 130 … 830 Next

SQLAuthority News – MVP Summit 2009 – Day 2 – Most Contributing MVP of Year

SQLAuthority News – MVP Summit 2009 – Day 3 – Party Day and SQL Celebrity Photos

SQLAuthority News – MVP Summit 2009 – Day 4 – Keynote of Steve Ballmer

SQLAuthority News – Author Visit – Toronto, Canada – Insert Image in Database

SQLAuthority News - Author Visit - Complete Wrapup of Microsoft MVP Summit 2009 Trip DSC03762

SQLAuthority News – Author Visit – Tech User Group Meeting, Markham, Canada and Toronto CA Solutions

SQLAuthority News – Author Visit – South Asian MVPs at Global MVP Summit 2009

SQLAuthority News – Author Visit – Complete Wrapup of Microsoft MVP Summit 2009 Trip

Previous 1 … 124 125 126 127 128 129 130 … 830 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 104 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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