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
Ice tongs lifting a cube from one side of a fixed trough divider

Recent Rows Only: A Filtered Index for the Data Everyone Reads

March 21, 2019
Pinal Dave
SQL Performance
Data Warehousing, Master Data Services, SQL Data Storage, SQL Index

A filtered index for recent rows is small and fast, but its date never moves by itself. Here is how to build it, test it and keep it fresh.

Read More
Four small wooden blocks sit around one larger central block on an oak tabletop.

Watching Many Servers Without Buying Anything

March 14, 2019
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Use scheduled snapshots to monitor SQL Server with central storage, failure reporting, and four focused queries collected every five minutes.

Read More
A finite group of loom stations serves a separate tray of waiting yarn bundles.

SQL SERVER – Default Worker Threads Per Number of CPUs

March 9, 2019
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Server

The default Worker Threads limit depends on SQL Server version, logical CPUs and memory. A workshop reader asked about automatic configuration.

Read More
Gouache painting of white card model houses on a drafting table with a vermilion waste bin nearby

Hypothetical Indexes in SQL Server: Find and Drop Them All

February 28, 2019
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Statistics

Hypothetical indexes are leftovers from the Database Engine Tuning Advisor. They hold a name and statistics but no data. This post lists them, shows they cannot serve a query, and drops them in two steps: a list you read first, and a drop second.

Read More
The morning catch sorted into shallow crates on ice on a harbor quay, a hand lifting one fish from a crate.

Eager Index Spool: When the Plan Builds Its Own Index

February 23, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Server

Investigate an eager index spool, read seek keys and output, and compare a supporting index with the cost of rebuilding temporary storage.

Read More
Gouache painting of a cabinet of drawers each holding a bolt and washers, one bolt in vermilion

Index Key Columns and Included Columns in SQL Server

February 21, 2019
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts

Index key columns and included columns show what each index really stores. This post builds one query that lists them for every index, then a second query that finds indexes with the same keys or a shared leading key. It ends with the rules for merging them safely.

Read More
Gouache painting of a toll plaza with two crowded lanes and one idle lane with a vermilion barrier arm

Update Statistics With FULLSCAN and MAXDOP in SQL Server

February 15, 2019
Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Scripts, SQL Statistics

To update statistics with FULLSCAN in parallel, add MAXDOP to the statement. This post builds a table of 3 million rows, times the update with MAXDOP 1, the instance default and 8, and shows which statistics speed up and which do not.

Read More
Previous 1 … 43 44 45 46 47 48 49 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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