Improve Query Performance when SQL Server Ignores Nonclustered Index

In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.

Explore Natively Compiled SQL Server Stored Procedure Execution Plans

In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.

The Complexity of Metrics

We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.

Performance Monitor Data

How Do You Experiment?

Today Steve is asking you if you experiment in your database.

Extreme SQL

Steve looks at how Facebook accelerates SQL queries.

SQL Server 2019 Feature

Memory Grant Feedback

Set Statistics Time Examples for Tuning SQL Server Queries

The SQL Server set statistics time statement displays the number of milliseconds to parse, compile, and execute a T-SQL query statement. This set statement is widely used to assess times to implement a query statement. The set statistics time statement reports the CPU time and elapsed time for performance tuning.

What Write Ahead Logging Is and Why It Matters

Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.