Category Archive

SQL Server

Memory module cluttered with small cards next to a neat stack, representing plan cache bloat and optimize for ad hoc workloads

Optimize for Ad Hoc Workloads: How to Stop Plan Cache Bloat in SQL Server

How to measure single-use plan bloat in the SQL Server plan cache, what optimize for ad hoc workloads does, when...

February 9, 2022

Control panel with toggle switches, one set differently, representing SQL Server SET options on objects

SQL Server Objects Created with the Wrong SET Options: Msg 1934, Filtered Indexes and ARITHABORT

Why procedures created with QUOTED_IDENTIFIER or ANSI_NULLS off break filtered indexes and indexed views with Msg 1934, how to find...

February 2, 2022

Oversized SQL Server transaction log made of many virtual log files overflowing next to a small database, with a warning gauge

SQL Server Transaction Log Too Big? Causes, Diagnosis and Safe Fixes

Why a SQL Server transaction log grows out of control, how to diagnose the real reason with log_reuse_wait_desc, and how...

January 19, 2022

Clock, server and a task list, representing Windows Task Scheduler jobs affecting SQL Server

Review Windows Task Scheduler: Hidden Jobs Behind Periodic SQL Server Slowdowns

How scheduled tasks on a database server cause slowdowns at the same time every day, how to list them with...

January 12, 2022

Puzzle pieces with one outdated piece set apart, representing deprecated SQL Server features

How to Find Deprecated Features in Use on a SQL Server Instance

How to see which deprecated SQL Server features are in use with performance counters, find the code behind them with...

December 29, 2021

Database, hourglass and a broken arrow to a disk, representing SQL Server delayed durability and log flush

SQL Server Delayed Durability: Faster Commits, Real Data Loss Risk

How SQL Server delayed durability returns commits before the log is hardened, how to enable it, when the data loss...

December 22, 2021

Processor splitting work into parallel lanes, representing SQL Server MAXDOP and cost threshold for parallelism

SQL Server MAXDOP and Cost Threshold for Parallelism: Recommended Settings

How MAXDOP and cost threshold for parallelism work together, Microsoft's MAXDOP recommendations by NUMA layout, how to choose a cost...

December 15, 2021

SQL Server database file being shrunk with scattered fragmented data pages next to a planned, well-organized storage block

SQL Server Shrink Best Practices: When to Shrink and When Not To

When shrinking a SQL Server database or file is justified, why it shouldn't be routine maintenance, how to shrink data...

December 1, 2021

Database with loose detached files, a magnifying glass and an archive box representing orphaned SQL Server data files

Offline Databases and Orphaned Data Files in SQL Server: How to Find and Remove Them Safely

How offline databases and orphaned .mdf/.ldf files accumulate in SQL Server, why they are a disk and data security risk,...

November 24, 2021

Database cylinder with a slider and a gauge, representing the SQL Server database compatibility level setting

SQL Server Compatibility Level: What It Changes and How to Raise It Safely

What the SQL Server compatibility level really controls, what changes at levels 150, 160 and 170, what happens to the...

November 17, 2021

Prev 1 … 5 6 7 8 9 10 Next