The culprit? Parameter sniffing. The solution? You guessed it: WITH RECOMPILE. Comprehensive Database Performance Health Check
SQL SERVER – Implementing Row-Level Security (RLS)
Row-Level Security (RLS) in SQL Server enables fine-grained control over data access, ensuring users can only view or modify rows pertinent to their roles or responsibilities.
SQL SERVER – Dynamic Data Masking (DDM) Introduction
Dynamic Data Masking (DDM) in SQL Server is a feature that helps protect sensitive data by masking it from unauthorized users.
SQL Server Ledger – Are You Really Using This Feature?
SQL Server Ledger – has taken data integrity to the next level, integrating blockchain-style data verification directly into the database.
Understanding the AUTO_DROP Option in SQL Server 2022
One such feature is the AUTO_DROP option for statistics. In this blog post, we’ll explore what the AUTO DROP option is, how it works.
FinOps Observability Fireside Chat: Elevating Database Management
FinOps Observability, the need for cost-efficient solutions in the database world is more critical than ever.
BULK INSERT Batch Size and ROWS_PER_BATCH
Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.