SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave

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.

An Index Reduces Performance of SELECT Queries (Video)
3 Common Mistakes to Kill SQL Server Performance (Video)
Click here for More Free Videos

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

Dec22

SQL SERVER – T-SQL Script to Check SQL Server Job History

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Jobs, SQL Scripts, SQL Server, SQL Server Agent

Yesterday my long time customer from New Zealand asked me during our regular weekly meet of Comprehensive Database Performance Health Check if I know a T-SQL Script to Check SQL Server Job History.

Dec21

SQL SERVER – How to Write Correlated Subquery?

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Table Operation

No Comments

This is a follow-up blog post to my earlier blog post written about SQL SERVER – Writing Your First Subquery From a Single Table. In the blog post, we discuss how to write a correlated subquery and why it is actually necessary. In a query, a correlated subquery is a subquery that uses values from the outer query. Subqueries are usually running once for each row processed for outer query and that is why they are often inefficient as well.

Dec20

SQL SERVER – Writing Your First Subquery From a Single Table

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server

No Comments

My primary responsibility is to help different organizations with tuning their SQL Server Performance and here is the link to my most popular service SQL Server Performance Health Check. I often encounter complicated performance problems which are not easy to resolve, however, recently during the lunch break, I was asked by Junior developer a question about writing a subquery from a single table by a Junior DBA at the organizations.

Dec19

SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files

Pinal Dave

SQL

Shrinking Database, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, Transaction Log

No Comments

Since I wrote my article about the script of shrinking the Log Files, there have been many emails from my blog readers about various messages.

Dec18

SQL SERVER – Information Message: Cannot shrink file in database to xxxx pages as it only contains yyyy pages.

Pinal Dave

SQL

Shrinking Database, SQL Error Messages, SQL Scripts, SQL Server

No Comments

I often get emails from my blog readers asking various types of clarifications about my own blog. Here is one of the interesting questions from a reader about message Cannot shrink file in the database to xxxx pages as it only contains yyyy pages which he encountered after following my below blog.

Dec17

SQL SERVER – Error 21028 : Replication Components are not Installed on This Server

Pinal Dave

SQL

SQL Error Messages, SQL Replication, SQL Server, SQL Server Management Studio, SSMS

One of my clients, for whom I installed SQL Server and configured AlwaysOn came back to me with an error message. While trying to configure replication they were getting an error message. In this blog, we would learn how to fix error “Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server”

Dec16

How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204

Pinal Dave

SQL Interview Questions and Answers

SQL Performance, SQL Scripts, SQL Server, SQL Statistics, SQL Table Operation

Question: How to Create an Empty Table and Fool Optimizer to Believe It Contains Data?

Answer: Before I answer this question, I must acknowledge that I have never heard this question in my 20 years career before and I must ask you back, where do you come up with these kinds of questions.

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 92 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.