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

Sep26

SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video

Pinal Dave

SQL Video

Database, Excel, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

SQL Server Management Studio returns results in Grid View, Text View and to the file. When we copy results from the Grid View to Excel there is a common complaint that the column header displayed in resultset is not copied to the Excel. I often spend time in performance tuning databases and I run many DMV’s in SSMS to get a quick view of the server. In my case it is almost certain that I need all the time copy column headers when I copy my data to excel or any other place.

Sep25

SQL SERVER – Basic Calculation and PEMDAS Order of Operation

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

After thinking a long time, I have decided to write about this blog post. I had no plan to create a blog post about this subject but the amount of conversation this one has created on my Facebook page, I decided to bring up a few of the question and…

Sep24

SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet

Pinal Dave

SQL Tips and Tricks

Excel, SQL Server, SQL Server Management Studio, SQL Utility, SSMS

I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.

Sep23

SQLAuthority News – Download SQL Server 2012 SP1 CTP4

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

There are few trends I often see in the industry, for example i) running servers on n-1 version ii) wait till SP1 to released to adopt the product. Microsoft has recently released SQL Server 2012 SP1 CTP4. CTP stands for Community Technology Preview and it is not the final version yet. The…

Sep22

SQL SERVER – Validating Unique Column Name Across Whole Database

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL System Table

I sometimes come across very strange requirements and often I do not receive a proper explanation of the same. Validating Unique Column Name

Sep21

SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Stored Procedure

I receive a lot of emails every day. I try to answer each and every email and comments on Facebook and Twitter. I prefer communication on social media as this gives opportunities to others to read the questions and participate along with me. There is always some question which everyone likes to read and remember. Here is one of the questions which I received in email. How to replace a column name in multiple stored procedure efficiently and quickly? I believe the same question will be there any many developers who are beginning with SQL Server. I decided to blog about it so everyone can read it and participate.

Sep20

SQL SERVER – 2 T-SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

NuoDB

365

We all love brain teasers and interesting puzzles. Today I decided to come up with 2 interesting puzzles and winner of the contest will get USD 50 worth Amazon Gift Card. The puzzles are sponsored by NuoDB. Additionally, The first 25 individuals who download NuoDB Beta 8 by midnight Friday, Sept.…

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.