Blog Home Page - Page 89 of 829 - SQL Authority with Pinal Dave

Mar 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Jul26

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

SQL Interview Questions and Answers

SQL Joins, SQL Scripts, SQL Server

Question: What is Full Outer Join With Exclusion?

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

Jul25

SQL SERVER – Counter Temp Tables For Destruction Not Working

SQL Tips and Tricks

SQL Counter, SQL Performance, SQL Scripts, SQL Server, SQL TempDB

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

Jul24

SQL SERVER Management Studio – Update Column Statistics Via SSMS

SQL Tips and Tricks

SQL Server Management Studio, SQL Statistics, SSMS

Today we will see how we can update Column Statistics via SSMS (SQL Server Management Studio). This feature was broken earlier and now fixed in SSMS 18.6.

Jul23

SQL SERVER – Input and Output Parameter for Dynamic SQL – Simple Example

SQL Tips and Tricks

Dynamic SQL, SQL Performance, SQL Scripts, SQL Server

Today we are going to a very simple example of the Input and Output Parameter for Dynamic SQL. I have been working on SQL Server for almost 20 years.

Jul22

Remove Bookmark Lookup – SQL in Sixty Seconds #089

SQL in Sixty Seconds, SQL Index, SQL Performance, SQL Scripts, SQL Server

We fixed the query performance by removing the bookmark lookup. Let us learn about that in today’s blog post, how we can fix this issue.

Jul21

SQL Server – T-SQL – Add and Remove IP Address to Azure Firewall

SQL Tips and Tricks

Computer Network, SQL Azure, SQL Server, SQL Server Security

The question was is there any way to list all the IP addresses which have access to the Azure Firewall and remove them via T-SQL in SSMS.

Jul20

SQL Azure – Add IP Address to Firewall

SQL Tips and Tricks

Computer Network, SQL Azure, SQL Server, SQL Server Security

However, recently my client was working from home and he was not able to access the SQL Azure database. Let us learn how we can and IP Address to Access.

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

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.

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.

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.