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
Jul31

Install MongoDB on Windows – SQL in Sixty Seconds #091

Pinal Dave
SQL Video
MongoDB, MongoDB Atlas, MongoDB Compass, SQL in Sixty Seconds
No Comments

Today I am going to demonstrate in this SQL in Sixty Seconds Video how to install MongoDB on Windows.  Let us see how we can do that in video.

Read More
Jul30

SQL in Sixty Seconds – Need Your Feedback

Pinal Dave
SQL Video
Feedback
2 Comments

I decided to spend more time in building the videos and have created three videos in the last three weeks. It is time when I need your feedback. 

Read More
Jul29

Creating Covering Index to Eliminate Join – SQL in Sixty Seconds #090

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Index, SQL Joins, SQL Performance, SQL Scripts, SQL Server
1 Comment

How to improve performance so today we are going to see a video about creating converting index to eliminate join and improve query performance.

Read More
Jul28

SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup

Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts, SQL Server
No Comments

I have received lots of questions based on this question about how to remove bookmark lookup. I have taken the 7 most asked questions and decided to answer.

Read More
Jul27

SQL SERVER – Finding Day Name from Date

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server
No Comments

In today’s blog post we will a very simple script where we will find day name from any valid date. There are multiple ways you can do it.

Read More
Jul26

What is Full Outer Join With Exclusion? – Interview Question of the Week #286

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

Question: What is Full Outer Join With Exclusion? 

Answer: I got this question after reading my earlier blog post about Basic of JOINs.

Read More
Jul25

SQL SERVER – Counter Temp Tables For Destruction Not Working

Pinal Dave
SQL Tips and Tricks
SQL Counter, SQL Performance, SQL Scripts, SQL Server, SQL TempDB
No Comments

They realized their counter Counter Temp Tables For Destruction Not Working and wanted me to help them. Let us learn about it today. 

Read More
Previous 1 … 86 87 88 89 90 91 92 … 830 Next

SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor

SQL SERVER – 2008 – Introduction to New Feature of Backup Compression

SQL SERVER – Deprecated DataType vardecimal

SQL SERVER - Find Space Used For Any Particular Table servicebrokeremail-800x200

SQL SERVER – Difference Between Database Mail and SQLMail

SQL SERVER – 2008 – Introduction to Row Compression

SQLAuthority News – Thank You to Awarding Author SQL MVP

SQL SERVER - Find Space Used For Any Particular Table sp_spaceused

SQL SERVER – Find Space Used For Any Particular Table

Previous 1 … 86 87 88 89 90 91 92 … 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