SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave

SQL Performance, SQL Server Configuration

SQL Video

SQL Server Performance Tuning and Optimization is how I earn my bread at home. Lots of people often ask if I will be happy to teach them my SQL Server Performance tuning tricks and my answer is very simple – of course. I am always willing to help people learn about SQL Server Performance Tuning if they are willing to learn about the subject. I have created some Free Performance Tuning Videos.

Dec24

SQL SERVER – Performing IF…THEN In T-SQL With IIF Expression

Execution Plan, SQL Performance, SQL Scripts, SQL Server

Today, we are going to see one of the most underutilized features of SQL Server IIF. In SQL Server we can performance IF…THEN logic in T-SQL with IIF Expression but I hardly see it being used at most of the organization.

Dec23

How to Track Autogrowth of Any Database? – Interview Question of the Week #205

SQL Interview Questions and Answers

SQL Performance, SQL Scripts, SQL Server, SQL Server Configuration

Question: How to Track Autogrowth of Any Database?

Dec22

SQL SERVER – T-SQL Script to Check SQL Server Job History

SQL DMV, SQL Jobs, SQL Scripts, SQL Server, SQL Server Agent

Yesterday my long time customer from New Zealand asked me during our regular weekly meet of Comprehensive Database Performance Health Check if I know a T-SQL Script to Check SQL Server Job History.

Dec21

SQL SERVER – How to Write Correlated Subquery?

SQL Scripts, SQL Server, SQL Table Operation

This is a follow-up blog post to my earlier blog post written about SQL SERVER – Writing Your First Subquery From a Single Table. In the blog post, we discuss how to write a correlated subquery and why it is actually necessary. In a query, a correlated subquery is a subquery that uses values from the outer query. Subqueries are usually running once for each row processed for outer query and that is why they are often inefficient as well.

Dec20

SQL SERVER – Writing Your First Subquery From a Single Table

SQL Scripts, SQL Server

My primary responsibility is to help different organizations with tuning their SQL Server Performance and here is the link to my most popular service SQL Server Performance Health Check. I often encounter complicated performance problems which are not easy to resolve, however, recently during the lunch break, I was asked by Junior developer a question about writing a subquery from a single table by a Junior DBA at the organizations.

Dec19

SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files

SQL

Shrinking Database, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, Transaction Log