• Log In
  • Contact Brent
Product has been added to your cart.
  • Consulting
    • Performance Tuning
    • Remote DBA Services
    • Upgrades and Migrations
    • Consultant Toolkit
  • Training
    • Conferences
    • My Videos and Downloads
    • My Account
    • Private SQL Server Training
    • Training FAQ
    • Watch Brent Streaming Live
  • Monitoring
  • Scripts
    • sp_Blitz – free health check
    • sp_BlitzCache – find queries to tune
    • sp_BlitzFirst – instant performance check
    • sp_BlitzIndex – design the right indexes
    • sp_BlitzWho – what’s happening right now
    • PasteThePlan – share query plans
  • Blog
    • T-SQL
    • Execution Plans
    • Indexing
    • Videos
    • Architecture
    • Backup and Recovery
    • Cloud Computing
    • Development
    • First Responder Kit
    • High Availability
    • Humor
    • Locking, Blocking, and Isolation Levels
    • Parameter Sniffing
    • Production Database Administration
    • Professional Development
    • SQL ConstantCare
Everybody wants the same thing: a stored procedure that has multiple parameters, and lets you search by any combination of values. Say we’re looking at the Stack Overflow Users table, and we want to search people by DisplayName, Location, and/or Reputation – we might want a proc that works like this: Transact-SQL EXEC usp_SearchUsers @SearchDisplayName...
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.
  • 01 – How NOLOCK Can Show Incorrect Results (10m)
  • 02 – Locking and Blocking (29m)
  • 03 – Deadlocks (18m)
  • 04 – Trivial Plans (17m)
  • 05 – Picking Index Key Order (34m)
  • 06 – Missing Index Column Order (21m)
  • 07 – Execution Plans are Lying Liars (24m)
  • 08 – Estimates vs Actuals (48m)
  • 09 – Table Variables vs Temp Tables: The 2019 Rematch (10m)
  • 10 – How Plans Are Cached (10m)
  • 11 – Parameter Sniffing (19m)
  • 13 – Dynamic SQL Pro Tips (34m)
  • 14 – Parallelism (38m)
  • 15 – Simplification (14m)
  • 16 – Filtered Indexes (23m)
  • 17 – Indexed Views (22m)
  • 18 – Computed Columns (14m)
  • 19 – Heaps of Sadness (11m)
  • 20 – Index Usage DMVs are Lying Liars (26m)
  • 21 – Resource Semaphore (37m)
  • 22 – Questions (17m)
  • Bonus – Building a Fork Bomb in T-SQL (11m)
  • Bonus – Managed Instance DTUs (4m)
  • Bonus – Memory Usage by Different Operators (15m)
  • Bonus: Numbers Tables (18m)

© Brent Ozar Unlimited®. All Rights Reserved.
Privacy Policy – Terms and Conditions

  • Consulting
  • Training
  • Monitoring
  • Scripts
  • Blog

Save your cart?

x