Skip to content

Darling Data

SQL Server Consulting, Education, and Training

Darling Data
  • Blog
  • Consulting
  • Learn
    • Pre-Recorded Classes
  • Scripts
    • sp_HealthParser
    • sp_HumanEvents
    • sp_HumanEventsBlockViewer
    • sp_IndexCleanup
    • sp_LogHunter
    • sp_PerfCheck
    • sp_PressureDetector
    • sp_QuickieStore
  • Contact
  • Health Check
  • Request a Call

The SQL Server Performance Tasting Menu: How Optional Parameters Hurt Query Performance

Posted on April 21, 2020May 16, 2022 by Erik Darling

NOOOOOOOO


Related Posts

  • The SQL Server Performance Tasting Menu: Performance Issues With Parallel Query Plans
  • The SQL Server Performance Tasting Menu: How DISTINCT Queries Can Hurt Performance
  • The SQL Server Performance Tasting Menu: How You Compare Date Columns Can Hurt Query Performance
  • The SQL Server Performance Tasting Menu: How Multi-Statement Table Valued Functions Hurt Performance
Posted in Tasting Menu

Post navigation

The SQL Server Performance Tasting Menu: Why Read Queries Block Write Queries Sometimes
The SQL Server Performance Tasting Menu: How To Count Distinct Values In SQL Server

You need SQL Server help.

I will make your SQL Server faster in exchange for money.

Click here for 50% off a health check:

Click here to get access to my performance tuning library for about $150 USD.

SQL Saturday NYC 2025

May 10th 2025 - Register Here!

Upcoming PASS Events 2025

PASS Summit On Tour:
* New York City, NY - August 18-20
* Dallas, TX - September 15-18
* Amsterdam, NL - October 1-3

PASS Data Community Summit:
* Seattle, WA - November 17-21

Copyright © 2019-2025 Darling Data
Last Updated on May 16, 2022 by Erik Darling