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
Illustrated cover: Troubleshooting High CPU

SQL SERVER – Troubleshooting High CPU

September 20, 2021
Pinal Dave
SQL Performance
SQL CPU, SQL Scripts, SQL Server

We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.

Read More
A jar of sourdough starter risen well above a red rubber band marking its earlier level.

Reading Performance Counters in T-SQL Without Misreading Them

September 17, 2021
Pinal Dave
SQL Performance
SQL Counter, SQL DMV, SQL Memory, SQL Monitoring

Read SQL Server performance counters with two timed samples, a proper ratio base, and a concise workload and memory dashboard.

Read More
Hands tying kindling sticks into bundles with twine beside a handcart stacked with finished bundles

Aggregate Pushdown: Letting the Columnstore Scan Do the Summing

September 13, 2021
Pinal Dave
SQL Performance
ColumnStore Index, Execution Plan, SQL Performance, SQL Server

Verify aggregate pushdown in columnstore scans, inspect locally aggregated rows, and compare numeric aggregates with expressions.

Read More
Matching cloth panels preserve their motif under two different folding methods.

SQL SERVER – Rebuilding Index with Compression

September 1, 2021
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server

To rebuild an Index with Compression, I target its own settings and partitions. Customer ROW and PAGE results need separate evaluation.

Read More
Gouache painting of a large bolt standing in a nut with a small vermilion knob on top, and a wrench lying beside it

Trigger Blocks Index Maintenance: How to Let Rebuilds Pass

August 26, 2021
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Trigger

A trigger blocks index maintenance when it guards every index event, because a rebuild is an index event too. This post shows the failure, then a trigger that reads EVENTDATA and lets rebuilds through while it still blocks create, drop and disable.

Read More
Gouache painting of a sunny courtyard with wooden stools holding saplings, the front stool vermilion

Index a Computed Column in SQL Server

August 20, 2021
Pinal Dave
SQL Performance
Computed Column, SQL Index, SQL Performance, SQL Scripts

To index a computed column, define the formula once on the table and create a normal index on it. This post loads 200,000 rows, shows the scan, then the seek after the index, and tests the rules that decide whether SQL Server accepts the column.

Read More
A worn shuttle is inspected over its finite work area beside a fresh unworn tool.

SQL SERVER – High Frequency Cached Query Counts and Statement Metrics

August 12, 2021
Pinal Dave
SQL Performance
SQL Cache, SQL DMV, SQL Scripts, SQL Server

I measure High Frequency cached statements with decimal executions-per-second arithmetic. A customer wanted to identify the busiest queries.

Read More
Previous 1 … 11 12 13 14 15 16 17 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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