SQL Server Performance Tuning Expert frontimage1

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.

SQL Server Performance Tuning Expert frontimage2

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.

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

SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book

I was recently reading excellent Just Learned Tip regarding 3 part naming Cannot be used when dropping Views,Functions or Procedures. This is quite a well known tip however, every developer and DBA learns at sometime in their career with ‘hm…’ moment. To illustrate this further here is a simple case…
Read More

SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32

Earlier I wrote an article where I demonstrated that an index with more than 16 column is not possible. Here is the link to the article. After reading the same article I received email from user suggesting does it mean that statistics can be only created on only 16 columns.…
Read More

SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012 – 4 Saturdays to Go

SQLSaturday 116 is now only 4 weeks away. SQL Saturday is FREE event all the attendees and 100% SQL community driven. Schedule and Venue Event Date: January 7, 2012 Event Time: 10 AM to 6 PM Event Venue: Microsoft Singature Building, Domlur, Bangalore , Bangalore, India Important Links: Register for…
Read More