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

Sep23

SQL SERVER – How to Join a Table Valued Function with a Database Table

Pinal Dave

SQL

SQL Function, SQL Scripts, SQL Server

Just another day I received following question and I find it very interesting. I decided to try it out on SQL Server 2016’s new WideWorldImporters database. The question was – “How to Join a Table Valued Function with a Database Table?” This is indeed very interesting as this particular feature was introduced in SQL Server 2008, so what you will see in this blog post applies to every version of SQL Server after SQL Server 2008.

Sep22

SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

Pinal Dave

SQL Performance

SQL Options, SQL Scripts, SQL Server, SQL Server Management Studio

As many of you know, I am an indecent SQL Server Consultant, who purely focus on SQL Server Performance. Every single day, I keep two slots each hour long available for users who need my help urgently. I never ever pre-book them because, I believe it is critical to help people who needs help NOW. Well let us learn in this blog post about how I recently helped a customer to improve performance by turning off AUTO_CLOSE Database Option.

Sep21

SQL SERVER – How to Hide Number of Rows Affected Message? – SET NOCOUNT

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Server Management Studio

In this blog post, we are going to talk about how to hide the number of rows affected messages with the help of SET NOCOUNT.

Sep20

SQL SERVER – Puzzle – Change in Date Format with Function

Pinal Dave

SQL Puzzle

SQL DateTime, SQL Function, SQL Scripts, SQL Server

168

Last week we had amazing time with an interesting puzzle about Datetime. You can see the puzzle over here. The puzzle was extremely well received and lots of people asked me to bring another puzzle which can help us learn something new. Looking at the request of everyone, here is another very simple puzzle with Date Format.

Sep19

SQL SERVER – How to INSERT or SELECT Copyright Special Characters in SSMS?

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server

I answer every email I receive in six hours and that is why sometimes I end up working over 18 hours in a day. However, sometimes I receive emails such that makes me wonder, how come I do not know some very simple stuff. Here is for example – today I received email where user asked how to INSERT or SELECT Copyright Special Characters in SQL Server. Trust me, in my early career, I used to know the answer to this, but I was not able to answer the user immediately. After quick googling, I was able to find out the appropriate character string.

Sep18

How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089

Pinal Dave

SQL Interview Questions and Answers

SQL Server, SQL Server Management Studio, Starting SQL

Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?

Sep17

SQL SERVER – 2016 – Wait Stats and Queues Script Updated – Identify Resource Bottlenecks

Pinal Dave

SQL Performance

SQL DMV, SQL Scripts, SQL Server, SQL Server 2016, SQL Wait Stats

NOTE: This script will just work fine with earlier version of SQL Server (2008, 2012, 2014) along with SQL Server 2016. It will give the expected results in all the SQL Server versions. This script will help you identify resource bottlenecks in your SQL Server.

A few years ago, I wrote the script which will help us identify SQL Wait Stats and Queues. It is a very popular script. You can find the link to the script over here: Introduction to Wait Stats and Wait Types. However, it has been a long time since I wrote that script and it was written for SQL Server 2008.

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