Jun 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
Jul13

SQL SERVER – How do I Learn and How do I Teach

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
11 Comments
This blog post is written in response to T-SQL Tuesday hosted by Robert L Davis (aka SQLSoldier). The blog post has raised three very interesting questions. How do you learn? How do you teach? What are you learning or teaching? Let me try to answer the same. How do I…
Read More
Jul12

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
154 Comments
I just received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the…
Read More
Jul11

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
3 Comments
Earlier I had posted article answering question. “When SQL Server executes any query on multiple processors, do all processors process equal numbers of rows?” Read the answer over SQL SERVER – Parallelism – Row per Processor – Row per Thread. In the same article, I had asked back to readers as…
Read More
Jul10

SQLAuthority News – Milestone – 1400th Post and Why do I blog

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
13 Comments
I am very glad today that I have reached milestone of 1400th post. I was looking back to my journey which I started on Nov 1, 2006 and I feel that it has been long way. I have noticed a lot of changes in myself too. Earlier, I used to…
Read More
Jul9

SQLAuthority News – I am a MVP and I Love SQL Server

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
MVP, SQL User Group
20 Comments
I am very glad that I received this prestigious award for the third time in a row. I am very thankful to Microsoft for introducing this wonderful technology of SQL Server. I enjoy getting involved with the community, which also helps in my self-improvement as well. I would like to…
Read More
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
Previous 1 … 628 629 630 631 632 633 634 … 831 Next

SQL SERVER – How do I Learn and How do I Teach

SQL SERVER - Upper Case Shortcut SQL Server Management Studio msdnfree

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN

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

SQLAuthority News – Milestone – 1400th Post and Why do I blog

SQLAuthority News – I am a MVP and I Love SQL Server

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

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

Previous 1 … 628 629 630 631 632 633 634 … 831 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 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 109 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.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

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