This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A hardware bench contrasts screws stored apart from hinges with a divided tray holding both together.

user_lookups: Verify the Plan Before Adding Coverage

March 25, 2009
Pinal Dave
SQL Performance
Clustered Index, SQL DMV, SQL Index, SQL Performance

user_lookups helps identify where to investigate missing coverage. Compare complete query results and actual plans before adding included columns. Weigh the read benefit against storage and write costs.

Read More
A planting dibber continues a row of holes beyond a bare rocky patch in a garden bed.

Updating a Large Table in Batches With a Moving Key Range

December 11, 2008
Pinal Dave
SQL Performance
Batch, Clustered Index, SQL Transactions, Transaction Log

Walk the clustered key a slice at a time, log each batch, and learn why stopping at the first empty batch quietly leaves rows behind.

Read More
Envelopes dropping through a letter slot into a large basket

Designing Tables for High Insert Rates

September 17, 2007
Pinal Dave
SQL Performance
Clustered Index, SQL Index, SQL Server, Table Partitioning, Transaction Log

High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.

Read More
Unmarked auger bits arranged in a wooden stand with one empty hole and a hand checking the tools.

Index Optimization Checklist: A Printable One-Page Guide

May 8, 2007
Pinal Dave
SQL Performance
Best Practices, Cheatsheet, Clustered Index, SQL Index

The twelve things I ask a junior DBA to check before I touch a slow query, with three quick proofs you can run yourself.

Read More
Previous 1 … 5 6 7 8
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com