Getting Wait Stats

Changing Database Names

SQL SERVER – FIX: Msg 4353 – Conflicting File Relocations Have Been Specified for File. Only a Single WITH MOVE Clause Should be Specified for Any Logical File Name

In this blog we would learn how to fix Msg 4353 - ...

Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy

Learn how you can configure clean and size management for your SSIS catalog database.

Delete offline database

Query Store in SQL Server 2019 (CTP 3.0)

Friends, CTP 3.0 dropped today, and it includes so...

SQL Server 2016: Here a NUMA, there a NUMA... Part 2

4x14 vcpus, 1472 total GB vRAM (368 GB per vNUMA n...

Setting MAXDOP During SQL Server 2019 Setup

Just a short note – in SQL Server 2019, the setu...

Event Log File Paths

How does one consistently find the correct path to...

SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression

Comprehensive Database Performance Health Check Cl...