Category Archive

Databases

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

Blocks of different shapes and sizes arranged in a row, representing SQL Server data types

SQL Server Data Types: How to Choose the Right Type and Avoid Implicit Conversions

How to choose SQL Server data types for integers, money, text, dates and more, why float is wrong for money,...

Prev 1 … 3 4 5