For the best web experience, please use IE11+, Chrome, Firefox, or Safari

SQL Server Tuning Tips #2

We are sorry, the event "SQL Server Tuning Tips #2" has already expired.

You may also be interested in.

On Demand Webcast

Why Query and Index Tuning Is So Darn Hard and How Toad Can Help
Why Query and Index Tuning Is So Darn Hard and How Toad Can Help

What is it about performance tuning that makes it so difficult? Solutions Consultant Gary Jerep will provide insight into why query and index optimization is so challenging. He’ll also demonstrate the Quest Software approach to tuning, so you can see ho

On Demand Webcast

How Can a DBA Participate in DevOps?
How Can a DBA Participate in DevOps?

You’ll see how DBAs can better understand changes occurring to their database servers, as well as how DBAs can provide performance-focused dashboards to developers to enhance collaboration between teams

On Demand Webcast

Automating SQL Server Database Management into an Azure DevOps Pipeline
Automating SQL Server Database Management into an Azure DevOps Pipeline

Azure DevOps is the go-to platform for Microsoft shops looking for a single-vendor solution for developing, testing, deploying and hosting their applications.

On Demand Webcast

Do You Feel the Need the Need for Speed in Your SQL Server Database. Are You Frustrated with Your Tuning Efforts?
Do You Feel the Need the Need for Speed in Your SQL Server Database. Are You Frustrated with Your Tuning Efforts?

Query tuning is key for SQL Server performance. But root-cause identification and resolution can be challenging and time consuming.

On Demand Webcast

Demystifying CXPACKET and CXCONSUMER
Demystifying CXPACKET and CXCONSUMER

Guidance on resolving the wait types CXPACKET and CXCONSUMER.

On Demand Webcast

Top 3 Execution Plans Mistakes and How to Avoid Them
Top 3 Execution Plans Mistakes and How to Avoid Them

Execution plans are the first-place database professionals go to tune their query, but they often provide misleading information. The science behind query optimization is knowing what to believe and what to ignore from the execution plan.

On Demand Webcast

Avoiding Deadlocks with Query Tuning
Avoiding Deadlocks with Query Tuning

Learn Brent’s tips to fix deadlocks. He’ll discuss tables in long transactions and why you need to work through them in a consistent order and touch them as few times as possible; then, he'll rewrite a stored procedure that's having deadlocking problems.