SQL Performance Archives - Page 92 of 120 - SQL Authority with Pinal Dave

A line of hands passing buckets, one hand holding a red bucket far too long

Finding the Slowest Statement Inside a Stored Procedure

October 20, 2009

Execution Plan, Query Store, SQL Performance, SQL Stored Procedure

Find the slowest statement inside a stored procedure using query stats offsets, CPU and read totals, then confirm with Query Store.

SQL SERVER – Enable Automatic Statistic Update on Database

October 15, 2009

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Statistics

Good indexes and a tuned query still ran slow because auto update of statistics was off. Enable Automatic Statistic creation and update, then update all stats.

SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3

October 12, 2009

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server

Part 3 of how to Remove Bookmark Lookup, RID Lookup and Key Lookup. A covering index holds every column the query uses in SELECT, JOIN and WHERE.

Two differently sized plain metal connectors resting beside a matching adapter on a wooden table.

The Implicit Conversion That Quietly Kills Your Index

October 10, 2009

Pinal Dave

SQL Performance

Best Practices, Database, SQL Scripts, SQL Server

Find an implicit conversion in your SQL Server plan, understand which value changes type, and match application parameters to indexed columns.

SQL SERVER – Queries Waiting for Memory Allocation to Execute

October 9, 2009

Pinal Dave

SQL Performance

SQL Memory, SQL Scripts

Find queries waiting for memory allocation with sys.dm_exec_query_memory_grants, plus wait_order and the query plan, when you suspect memory is short.