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
Overlapping braces are reviewed beside selected fittings and preserved original pieces.

SQL SERVER – Say No To Database Engine Tuning Advisor

February 5, 2019
Pinal Dave
SQL Performance
SQL Index, SQL Server, SQL Statistics

I review Database Engine Tuning Advisor recommendations against the workload before applying them. That was the point behind my original opinion.

Read More
A wooden log flume on a hillside with logs queued at the top and a red log stuck midway.

WRITELOG Waits: Finding What Slows Transaction Log Writes

February 4, 2019
Pinal Dave
SQL Performance
SQL Performance, SQL Server, SQL Wait Stats, Transaction Log

Diagnose WRITELOG waits with log-file latency, commit patterns, and measured choices for batching, storage, and durability.

Read More
Tightly rolled fleeces in a row on a barn floor, beside an open hamper of loose wool waiting to be rolled.

Columnstore Bulk Load: Why Batch Size Decides Where Rows Land

January 22, 2019
Pinal Dave
SQL Performance
ColumnStore Index, Data Warehousing, SQL Index, SQL Server

Review columnstore bulk load batch sizes, inspect delta and compressed rowgroups, and measure the cost of forcing small groups to compress.

Read More
A hand turning a heap of inside-out children's clothes right side out one by one to find a red jumper.

Implicit Conversions That Quietly Turn Seeks Into Scans

January 18, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Datatype, SQL Index, SQL Performance

Find implicit conversions in SQL Server plans, compare parameter and column types, and fix type contracts without losing Unicode data.

Read More
A garden hose nozzle with a red dial, one sharp jet and one wide gentle shower over flower beds

Catch-All Queries and Optional Parameter Plan Optimization in SQL Server 2025

January 18, 2019
Pinal Dave
SQL Performance
Dynamic SQL, Parameter Sniffing, Recompile, SQL Server

Compare catch-all queries with recompilation, parameterized dynamic SQL, and SQL Server 2025 optional parameter plan optimization.

Read More
Two gaskets beside a pipe flange being checked for fit and thickness

Index Size Estimate: Sizing an Index Before You Create It

January 17, 2019
Pinal Dave
SQL Performance
Clustered Index, ColumnStore Index, SQL Index

Before you build an index, estimate its size and say what you assumed. Then check the guess against real pages on a copy.

Read More
Gouache painting of a greenhouse wall with one clean pane and a vermilion squeegee on the sill

Clear the Plan Cache for a Single Database in SQL Server

January 9, 2019
Pinal Dave
SQL Performance
SQL Cache, SQL Scripts, SQL Server Configuration

To clear the plan cache for one database, use ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE in that database. This post tests it on two small databases, compares it with DBCC FLUSHPROCINDB and with freeing a single plan, and explains why DBCC FREEPROCCACHE is a bad habit.

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

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