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
An added courtyard divider creates a side detour beside a visible direct route.

SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries

June 4, 2019
Pinal Dave
SQL Performance
SQL Index, SQL Server, SQL Training, Webinar

An index can reduce the Performance of SELECT Queries when it changes a particular plan unfavorably. Readers asked three follow-up questions.

Read More
A hotel luggage room where a sprawling heap of small overnight bags takes more floor than the trunks and suitcases

Plan Cache Memory by Cache Store: Where Plans Use Your RAM

May 30, 2019
Pinal Dave
SQL Performance
SQL Cache, SQL DMV, SQL Memory, SQL Server

Break down plan cache memory by cache store and object type, compare memory clerks, and investigate unused plans without cache clearing.

Read More
Gouache painting of a vermilion spice rack crowding a kitchen counter beside a cutting board of sliced vegetables

Index Slows Down SELECT? What an Unused Index Costs You

May 28, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Statistics

An index slows down SELECT queries only in small ways when the plan never reads it. This post measures compile memory with twelve unused indexes, shows the plan change when a related index appears, and counts what every insert and update pays. The real bill arrives on writes.

Read More
A hand removes an empty walnut shell from a rack crowded with whole nuts and hollow shells

Columnstore Deleted Rows: When the Delete Bitmap Slows Scans

May 17, 2019
Pinal Dave
SQL Performance
ColumnStore Index, SQL Index, SQL Performance, SQL Server

Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.

Read More
Illustrated cover: Instant Rollback

SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback

May 13, 2019
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server 2019, SQL Transactions, Transaction Log

Killing a long transaction used to mean a rollback that took forever. SQL Server 2019 fixes that with Accelerated Database Recovery and its instant rollback.

Read More
Three different inspection tools sit beside the same workpiece and retained samples.

SQL SERVER – How Do I Evaluate Monitoring Tools?

May 8, 2019
Pinal Dave
SQL Performance
SQL Monitoring, SQL Server, SQL Utility

I evaluate monitoring tools by collection cost, historical context and usefulness in choosing a correction. Customer discussions shaped those three criteria.

Read More
Gouache painting of a clay pot beside the vermilion wooden form it was shaped around

Compiled Parameter Values in SQL Server: Read Them From the Cache

May 7, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL DMV, SQL Stored Procedure

Compiled parameter values show which value SQL Server used when it built a cached plan. This post reads them from the plan cache with one query, then shows how the first caller shapes the plan for everyone after. It ends with the usual ways to break that link.

Read More
Previous 1 … 40 41 42 43 44 45 46 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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