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

Sep30

SQL SERVER – UPDATE FROM SELECT Statement with Condition

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Table Operation

An email from an old college friend landed my mailbox about UPDATE FROM SELECT Statement with Condition:
“Hey Pinal,”
I have two tables. I want to conditionally update data in one table based on another table. How can I do that. I have included sample scripts and an image for further explanation.

Sep29

SQL SERVER – How to Check Snapshot Isolation State of Database

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

It is very easy to know the snapshot Isolation State of Database and here is the quick script for the same. SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc , is_read_committed_snapshot_on FROM sys.databases s Upon running above code it will return the results describing the status of the isolation level for your…

Sep28

SQL SERVER – SQL Server 2008 R2 Service Pack 3 – Download

Pinal Dave

SQL

SQL Download, SQL Server, SQL Service Pack

No Comments

It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack 3and its feature pack. SQL Server 2008 R2 SP3 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 R2 Service Pack 2 up to and including Cumulative Update 13.

Sep27

SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures

Pinal Dave

SQL Tips and Tricks

In-Memory OLTP, SQL Server

No Comments

Earlier I wrote a blog post about the Location of Natively Compiled Stored Procedure and Naming Convention. In this blog post, I wrote about location of natively compiled stored procedures.

Sep26

SQL SERVER – Performance Dashboard – Historic Information

Pinal Dave

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

SQL Reports

There are a lot of games that I play with my daughter in spare time. Some of them are for just for fun and a lot of them are fun filled with some learning. As she started to grow up, it was important for me to weave learning into her…

Sep25

SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047

Pinal Dave

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

Notes from the Field

[Notes from Pinal]: There are few things which confuse us when we encounter first time, however, there are few concepts which confuses us even though we face them multiple times. One of the such subjects is database taking a long time to create. Think about it, if you see a…

Sep24

SQL SERVER – Performance Dashboard: Current Activity Section Reports

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports

You are driving on the highway and you want to know your speed because there are cops generally in that areas – you watch the dashboard. Your kid seems to be fiddling with your cell phone – you want to see what they are doing actually and not accidentally making…

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.