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
Hands tipping a large milk churn over a small teacup, milk flooding the table, a tiny cream jug unused

SELECT * in Production Code: The Hidden Costs

April 18, 2011
Pinal Dave
SQL Performance
SQL Coding Standards, SQL Index, SQL Server, SQL View

See the real costs of SELECT * in production code: lost covering indexes, lookups, stale view metadata, broken inserts and wider results.

Read More
A finite ceramic reservoir supplies two vessels through separate connected spouts.

SQL SERVER – TempDB in RAM for Performance

April 10, 2011
Pinal Dave
SQL Performance
SQL Server, SQL TempDB

TempDB in RAM needs a review of capacity, support and memory pressure. I compare those costs with the bottleneck it would address.

Read More
Hands feeding a long knotted rope into harbor water, a red rag tied at a knot far down the line

OFFSET FETCH Paging and Its Deep Page Problem

April 5, 2011
Pinal Dave
SQL Performance
SQL Order By, SQL Paging, SQL Performance, SQL Server

Use OFFSET FETCH with a unique sort order, compare early and deep page reads, and decide when a cursor based approach fits better.

Read More
Pebbles sorted into heaps by size along a driftwood plank on a beach, one heap much taller than the others.

Statistics Histograms Explained

March 22, 2011
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server DBCC, SQL Statistics

Statistics histograms explained through steps, RANGE_ROWS, EQ_ROWS, and DBCC SHOW_STATISTICS help connect data shape to plan estimates.

Read More
Comic strip: the critic in a gray raincoat orders the Garden Hash, Casey calmly lets the ticket wait one minute on the rail, and the critic leaves a napkin that makes Quinn beam and Ace cry happy tears. Casey says, "Cooking four, waiting one. A normal Tuesday."

Wait Stats Summary: Every Wait on One Page

February 28, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Performance, SQL Scripts, SQL Wait Stats

This wait stats summary puts every wait from the series on one page: what it means and the first fix to try. On Night 28 at the Clipboard Diner, the critic finally comes on an ordinary Tuesday. The lesson of the whole series is the same as the story’s: know what normal looks like on your server.

Read More
Comic strip: Casey turns four weeks of notes into a one page chart, Ace tries to fix everything at once, and then gets caught about to wake the sleeping night baker with a pot. Jules says, "Night baker on top? Cross it out. Read the next one."

Wait Stats Troubleshooting: From Top Wait to First Fix

February 27, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Performance, SQL Scripts, SQL Wait Stats

Wait stats troubleshooting comes down to one habit: find the top real wait, ask its first question, and try one fix. On Night 27 at the Clipboard Diner, Casey tapes a one-page chart to the fridge. Here is that chart for SQL Server, plus one query that shows your top waits with their share and signal percent.

Read More
Comic strip: four cooks build one giant cookie tray, three of them wait on Jesse's heavy bowl of chunky dough, and with the dough split evenly they all finish at once in a synchronized dance pose. Casey says, "Even bowls, short wait. The tray was never the problem."

Batch Mode Wait Stats: HTBUILD and Columnstore Waits

February 26, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Memory, SQL Wait Stats

Batch mode wait stats such as HTBUILD and BPSORT show threads waiting for each other inside a parallel batch mode plan. On Night 26 at the Clipboard Diner, four cooks wait for one giant shared tray before 900 cookies can bake. Then I show when these waits are normal, when skew or spills make them a problem, and how to check them.

Read More
Previous 1 … 79 80 81 82 83 84 85 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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