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

Sep25

Identify Used Space in Log File- Interview Question of the Week #090

Pinal Dave

SQL Interview Questions and Answers

SQL Log, SQL Scripts, SQL Server, SQL Server DBCC

Question: How to identify Used Space in Log File?

Answer: Use following command to display used log file size and total used space in the log file.

Sep24

PowerShell – Reading Tables Data Using Script

Pinal Dave

SQL

Powershell, SQL Server, SQL Table Operation

Earlier in this blog, I have written a number of posts by using PowerShell. The more you play around with this scripting language more are the hidden gems that come out. Personally for me, everyday is like a new learning that needs to be discovered working with SQL Server and PowerShell.

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.

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