Posts by Sangeetha Sundaramoorthy

Enabling Query Store on SQL Server 2019

Introduction:  When it comes to database performance tuning, that’s where Query Store appears. Introduced in 2017 version and significantly enhanced in 2019, Query Store acts like a “flight recorder” for…

Read More

Archiving and Deleting Data From MS SQL Server Database 

Archiving and Deleting Data From SQL Server Database  Server: SERVER1  Main Database: DB1  Archive Database: DB1_archive  Target Table: dbo.PerformanceCounters  Objective:  To archive and delete data older than 90 days from…

Read More