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

Aug7

SQLAuthority News – Community Tech Days, Ahmedabad – July 24, 2010

Pinal Dave

SQLAuthority News

SQL User Group, SQLAuthority Author Visit

No Comments

Community Tech Days are a series of events in my city. Ahmedabad Community is one of the best communities I have ever come across in this world. People are genius, very kind and very patient. They are not shy to ask any questions and I could see their keen desire to learn and absorb new technology. My special thanks to the Community because without them, this event series would not be possible.

Aug6

SQL SERVER – Parallelism Query in Database

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

I recently came across two interesting questions asked by Feodor over here. He has asked very interesting questions. Please check them as follows: If I have a dual core computer and I would like to get a query executed with parallelism in order to test it, how would I do…

Aug5

SQLAuthority News – SQL Data Camp, Chennai, July 17, 2010 – A Huge Success

Pinal Dave

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

MVP, Spatial Database, SQL Index, SQLAuthority Author Visit

I had great pleasure to attend very first SQL Data Camp at Chennai on July 17, 2010. This event was very unique as this was very first one-day SQL Event in whole Indian Subcontinent. The event was blast as there were so many back–to-back SQL Sessions with SQL Server MVPs.…

Aug4

SQL SERVER – Computed Column – PERSISTED and Performance – Part 2

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

This is the third article in the series which I am writing on Persisted Columns. I suggest you read following two article first before continuing on this article. This is the list of the all the articles in the series of computed column. SQL SERVER – Computed Column – PERSISTED…

Aug3

SQL SERVER – Computed Column – PERSISTED and Performance

Pinal Dave

SQL Performance

Computed Column, SQL Scripts, SQL Server

This is the list of the all the articles in the series of computed column.

Aug2

SQLAuthority News – T-SQL Challenges and Hints and Suggestions

Pinal Dave

SQL Puzzle

SQL Server

Those who read my blog are for sure know my very good friend Jacob Sebastian. He is SQL Server MVP and founder of wonderful site T-SQL Challenges. No matter how expert we are, challenges are made to make us think and try to go to next level. There are certain people who writes always challenging code, however there are many who are yet not expert but the passion of T-SQL is on them. Jacob has many wonderful ideas and T-SQL challenge is his contribution to community, where he helps community to think, help them to mentor and help them to become one better coder.

Aug1

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Function, SQL Scripts

In one of the recent consultancy, I was asked if I can give working example of BINARY_CHECKSUM. This is usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows.…

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.