Feb 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
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Jul8

SQL SERVER – The Self Join – Inner Join and Outer Join

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Joins, SQL Scripts
50 Comments
Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The…
Read More
Jul7

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio
37 Comments
Few days ago, I received code which is very similar to code shown below. select * from Sales.SalesOrderDetail where ProductID > 777 I am not the guy who go crazy for formatting but I do appreciate proper coding. I like if the code was formatted like below. SELECT * FROM…
Read More
Jul6

SQLAuthority News – I am Microsoft Certified Trainer (MCT)

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Training
18 Comments
I am a Microsoft Certified Trainer and I am very much proud of it. Because I am a MCT, I have the support of great community leaders and trainers who help me constantly to improve in what I do. I have many Microsoft Certifications and I constantly try to take…
Read More
Jul5

SQL SERVER – PowerShell Version Info

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Powershell, SQL Scripts
2 Comments
I have multiple computer systems at home. I have previously taken a picture of my home office and published it here. Also, I recently had a scenario where I was listing a PowerShell version installed in my computer systems. While searching online, I found two different commands that can determine…
Read More
Jul4

SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts
8 Comments
In the recent Query Tuning project, one of the developers who were helping me out in the project asked me if there is any way that he could know how many pages are used by any Index,  and if there is any way I could demonstrate the different levels of…
Read More
Jul3

SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Execution Plan, SQL Scripts, SQL Server Management Studio, SQL XML
8 Comments
Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also…
Read More
Jul2

SQL SERVER – Parallelism – Row per Processor – Row per Thread

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio
5 Comments
Here is a question I received via email: “When SQL Server executes any query on multiple processors, do all processors process equal numbers of rows?” I find this one very interesting. I quickly wrote down a query which can run on multiple CPU in my machine. My laptop has a…
Read More
Previous 1 … 627 628 629 630 631 632 633 … 829 Next
SQL SERVER - Optimal Value Max Worker Threads memdb

SQL SERVER – Script to Identify Memory Used By Each Database

SQL SERVER - Optimal Value Max Worker Threads cardinalityofcolumn1

How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177

SQL SERVER - Optimal Value Max Worker Threads convertimplicit0

SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?

SQL SERVER - Optimal Value Max Worker Threads twomisc

SQL SERVER – SSMS 17.7 Observation – Two Miscellaneous Category in Database Property Options

SQL SERVER - Optimal Value Max Worker Threads inor2-800x442

SQL SERVER – Performance Comparison IN vs OR

SQL SERVER - Optimal Value Max Worker Threads ssmsdelete2

SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?

SQL SERVER - Optimal Value Max Worker Threads maxworkerthread1

SQL SERVER – Optimal Value Max Worker Threads

Previous 1 … 627 628 629 630 631 632 633 … 829 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 100 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