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 tall hourglass on a windowsill, the upper bulb full of sand and a thin stream falling through the narrow neck.

Making SSIS Packages Faster

January 13, 2013
Pinal Dave
SQL Performance
ETL, SQL Performance, SQL Server, SSIS

Make SSIS packages faster by measuring each flow, using fast load, sizing buffers from row width, and replacing row-by-row work.

Read More
Gouache painting: two wooden ladders leaning on one orchard wall, a short one beside a tall one with identical lower rungs, one vermilion rung on the short ladder

Redundant Indexes: Index on Col1, Col2 vs Col1, Col2, Col3

January 4, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL DMV, SQL Index, SQL Scripts

Redundant indexes cost space and slow every write, but not every one can go. This post measures an index on Col1, Col2 next to an index on Col1, Col2, Col3 on SQL Server 2025: size, plan, reads and log bytes. It ends with a safe way to remove one.

Read More
A brass plumb bob on a string beside a leaning brick wall, with a trowel and mortar bucket waiting on the grass

Performance Baseline in SQL Server: Measure Before You Tune

January 1, 2013
Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, SQL Performance, SQL Server

Build a performance baseline in SQL Server with saved waits, file latency, query CPU, and counters before judging a tuning change.

Read More
A cleared hallway with rugs rolled up against the wall and a wardrobe just brought in.

Disabling Nonclustered Indexes Before a Large Load, Then Rebuilding

December 22, 2012
Pinal Dave
SQL Performance
DBA, ETL, SQL Index, SQL Server

Test disabling nonclustered indexes before a large load, rebuilding them afterward, and measuring total time and log use.

Read More
A combined glass-cutting tool beside separate scoring and breaking tools

MERGE Performance for Large Upserts: UPDATE Then INSERT Instead

December 21, 2012
Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Server

Is MERGE really slow, or did the rewrite just run on a quiet night? Here is a fair test you can run yourself.

Read More
Four ants carrying crumbs, the last one far behind under a huge red crumb

Uneven Parallelism: Spotting Skewed Threads Behind CXPACKET Waits

December 15, 2012
Pinal Dave
SQL Performance
Execution Plan, MAXDOP, Parallel, SQL Wait Stats

Diagnose uneven parallelism by comparing CXPACKET and CXCONSUMER with per-thread row counts in plans and live query profiles.

Read More
A cork borer and extracted core beside intact and fully opened cork stoppers

SAMPLED vs DETAILED: Running index_physical_stats Safely

November 26, 2012
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Server

A misspelled table name quietly turns into a scan of everything. Here is the guard, and a fair comparison of the three scan modes on one small index.

Read More
Previous 1 … 71 72 73 74 75 76 77 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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