Tag: Performance Tuning

CXPACKET and CXCONSUMER wait types in SQL Server are common occurrences when managing database performance. Learn Brent Ozar’s advice on how to fix them.

Learn how to avoid SQL deadlocks through query tuning, courtesy of Microsoft Certified Master Brent Ozar.

SQL Server execution plans are a gateway for query optimizer and query executions. Learn how to read, interpret and analyze execution plan data.

When SQL query optimization is needed, apply these best practices to improve database performance first.

Here are three key areas to focus your SQL Server performance tuning efforts to keep your database in peak condition.

Learn the many use cases for the SQL CASE statement and how it applies business logic to SQL Server.

Learn about the primary diagnostic tool for poor query performance—execution plans and see how estimated and actual SQL Server execution plans can differ.

You are bound to run into SQL Server deadlocks when managing SQL Server. Learn what they are, why they occur and the best ways to avoid them.

There are several best practices to consider when using a SQL delete statement to remove data from a SQL table. Learn how to use it properly.

These 11 SQL Server index best practices will help you ensure peak database performance and improve your approach to performance tuning.