Blog

Archive:

Search site:

Tags:

Concurrency (3) debian (2) docker (2) Execution Plans (6) Indexes (4) internals (11) linux (5) MongoDB (2) MR2 (2) Optimization (7) Parameterization (1) Performance (9) Performance Tuning (3) postgres (6) Powershell (2) RCSI (2) SQL Server (26) Statistics (2) Stored Procedures (1) Version Store (2)

Categories:

Docker (2) Linux (4) MongoDB (2) PostgreSQL (6) Powershell (1) SQL Server (26)

Tag: Parameterization

  • Curse of the Catch-All query

    Curse of the Catch-All query

    The catch-all query – a fairly common pattern that is often seen in SQL Server apps where there is a list of results that can be filtered by one or more criteria. This usually takes the form of a stored procedure that is constructed as below. The example stored procedure is created in the Stack…

    Keep reading