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

Apr26

SQL SERVER – UNION ALL and UNION are Different Operation

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Union clause, Union

I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and again. Let us learn about the different operations about the unions.

Apr25

SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, Union

“How do I return a few of my resultset rows at the bottom of the entire resultset?” I was previously asked this question and my response was that we can do this by using the CASE statement in the ORDER BY clause and I wrote a blog post describing the…

Apr24

SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, sqlcmd

This journey of SQL in Sixty Seconds we started almost a year ago and today we are at very interesting milestone where I am recording 50th episode. Thought I wanted to keep the length of each video to sixty seconds, sometimes it went up by a few seconds. Due to this we are also at very…

Apr23

SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server

“How do I return a few of my resultset rows at the bottom of the entire resultset?”

Apr22

SQL SERVER – Discussion – Scale-up vs Scale-out Architectures

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

Note: NuoDB is a complete re-think of relational databases with innovative support for the Cloud’s dynamic, asynchronous nature. Download NuoDB to experience the Scaling Out scenario discussed in this blog post. Scaling Up There are many different ways of scaling SQL Server to accommodate more transactions and throughput. The general scale-up approach includes:…

Apr22

SQLAuthority News – Webinar SQL Server Locking and Concurrency by Rick Morelan

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

My book co-author Rick Morelan is giving away SQL Queries Book and DVD set (valued at over $200) in his next webinar. SQL Server is known for handing many requests at once and updating as new data comes in. If concurrency allows many things to happen at once, and locking prevents…

Apr21

SQLAuthority News – Women in SQL – Youngest SQL Speaker – Bangalore SQL User Group Event on April 20, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQLAuthority Author Visit

It was a great day today as at a SQL Bangalore User Group we had an event “Women in SQL” day. This event was one of the milestone event as in India there was no UG in my knowledge had done an event where we appreciated “Women Power”. We had…

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.